• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multi Table PDF import

davaze

New Member
I was wondering if someone could give me some direction on how to create one table record from a multi table pdf import. Sometimes after import a pdf it results in one table record for all the tables across multiple pages in the pdf and sometimes it results in multiple table records for each table page found in the pdf. Because i'm feeding this one record table inside a fuction which skips rows and promote header based on a keyword as parameter, i need one record which holds the whole table. In case the output has mutiple records with a table, the function will check each table record to do the skip and promote and because only the first table has the header the other tables will result empty because the other table records are the same tables without the header..
Is there a way to merge these mutliple table records (found on each pdf page) into one single table record that holds all the tables as one single table, similar like if the pdf was imported as one single table over multiple pages?
I know i can expand the tables and it will give me the whole expanded table from all table records but i need the output as one record which holds the table (nested) as table.
I hope above is a bit clear otherwise i will try to add some pictures.
Maybe i'm thinking too difficult here and there is an easy way of doing this. Would apperciate any ideas.
Thanks!
 
Well, i guess i found a way to do what i want but i'm not sure if this is the correct way..
First i expand all the columns of the imported pdf. This will expand all the tables into one expanded table.
Then in the next step i just put {} around the previous step which will create a list of that whole table.
Then i do a Table.FromList in the next step which will then create one column with one record as a table again. Which holds all the data from the previous expanded pdf tables.
Now i have all the original pdf tables show up as one nested table again.
If there is a better way of doing this then let me know because now i need to expand the table first and then create a nested table from it again.
It would be good if i could do it without having to expand the tables first.

Thanks.
 
Back
Top