Forum Discussion
New files have additional column in table
- 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.
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.