New files have additional column in table

[Justas4478]

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 them I got this error in power query.

Is there way to fix it or I have to make new folder location for older invoices and inport them separately and mearge them with new one's later on?

[MFelix]

Hi @Justas4478 ,

Has you refered this is because of the missing column and when it tries to run the changes to the transformation it does not encounter the column and returns a blank.

Are you making a lot of transformation in the function or only a simple formatting of the data?

If you are only using the function to pick the data and format the column I would remove the step of the formatting from the function and that should fixed the problem since the column names won't be called at any point in time, if you are doing more steps then you need to do a more advance query and adding a column before starting the chagnes.

This can be achieve adding a code similar to this righ after the Navigation step on the Function:

if Table.HasColumns (Table1_Table, {" "} ) then  Table1_Table else Table.Combine ({Table1_Table, Table.FromRows ({},{" "})})

See full details on the video below:

[speedramps · Accepted solution]

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.