Forum Discussion

diego_martinezn's avatar
diego_martinezn
Frequent Visitor
4 years ago

Losing a column when importing PDF

I'm working with a folder where I have some PDFs, all with the same structure.  I've developed a function to just upload the files to that folder and automatically apply all transformations and oper...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

To prevent this, I always add a ColumnCount column that tells me the number of columns in each pdf table.  Then I sort by greatest to least.  This way, your sample file has the maximum number of columns, and when you expand them, you will no longer lose any data!

 

--Nate

  • diego_martinezn's avatar
    diego_martinezn
    Frequent Visitor
    4 years ago

    Hi Anonymous , first of all, thank u for answering.

    Here it's what I've done based on your answer. I add a personalized column where I count the number of columns of each table and sort them, so what I get is three tables sorted as follows: {21columns, 11 columns, 9columns}.

    Then I click on the expand button, and as you said the whole new table has 21 columns but it fills with "nulls" where my missing data should be. 

    I think this procedure is what you meant right? Maybe I'm skipping some steps or don't do it correctly. Let me know 🙂