Forum Discussion

Mederic's avatar
Mederic
Post Patron
1 year ago
Solved

Tables combine

Hello everyone, I would like to combine several tables from the same file and keep only certain columns. The problem is that the column headings are not always in the same place. I have attached a...
Need Help
  • Mederic's avatar
    Mederic
    1 year ago

    Thanks again,
    I put the tables in an Excel file because I couldn't add the PDF invoice.
    Indeed the import process is different.
    I don't want to charge any pages from the PDF (tables) into the tabs, but rather the result directly.
    I was inspired by this video for the process.
    I don't understand the language, but it allowed me to get the result that I put in my previous example files.

    Best regards,

Mederic's avatar
Mederic
Post Patron
1 year ago

Hello MasonMA ,

Thank you again for your help.
I'm not sure I can apply some of your steps to my object of Tables without expanding them.

I'will using a Text parameter and adding it directly to my Source.
I've tested it on several invoices and "Document No" always appears in column 2 and on the 3rd line.
I'll use this method even if it's not ideal.

Have a good day.
Best regards,

MasonMA's avatar
MasonMA
Super User
1 year ago

Hello Mederic 

 

Could you share your M code? 

I got confused again. In your message yesterday, it was mentioned Document No. - 'This information is sometimes in column 2 or 3.'

However in your last message, '"Document No" always appears in column 2 and on the 3rd line.'


If you could review my initial message, the logic is cleaning the tables until your have no Null or columns with unrelated info Before you use Table.Comnine and then transform your Document No. column from there. 

 

However , I wouldn't be able to validate them unless I see your PDF files. Anyways, It's great you have another solution. 


Happy to chat on platform. 

 

 

 

 

  • Mederic's avatar
    Mederic
    Post Patron
    1 year ago

    MasonMA 

    Here is the file with the code I use, which works on my personal PDF files.
    Sorry, I created an example that did not correspond 100% to the PDF extraction.
    The "Order" and "Amount" columns are always in the same column number.
    Only the Document number changes.

    Best regards,