Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

New files have additional column in table

Hi, I have load of invoices that I need to to combine. The problem is that new invoices table has 11 columns and older invoices have 10 New table: Old table: When I tried to combine t...
  • speedramps's avatar
    1 year ago

    The new table has an extra column with no heading.

     

    In Power Query, 
    Near the top step of your query
    use the shift or ctrl key to select all the required columns.

    Then right click and "Remove Other Columns".

     

    If the users ever accidentally add extra columns the query will remove them.

    So you old and new tables will be consistent.

     

    Please be polite and click thumbs up because I have tried to help.

    Then click [accept solution] if it works.

    Thank you.