Power Query Get Data From Folder. Adding New Column

Question

Hello,

I am trying to see if what I am doing is possible. So weekly I get an CSV file with all the same columns and format that I keep in a folder and use power query to combine/edit them all. However occasionally the file will have a new column on the end when we have a new item. In the past I would just go back through all the old files and add this column manually to them. However as I get more and more files (20+) this is becoming time consuming to do. Is there a way to not have to do this? When I just add the new file with the additional column then try to refresh the query it gives me an error. Is this possible or do I need to keep adding these columns manually?

Thank you,

Answer 1

A screenshot is not helpful. Again: Show us a sample file or at min a sample CSV and your MCode.

Andreas.

Answer 2

So for example this is the new column I would need to add for this week.

Answer 3

Show us a sample file or at min a sample CSV and your MCode.

Andreas.