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!
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!