Forum Discussion
New column added in between in Source CSV, data imported from folder
Hi all, My data is imported from folder, everyday a new CSV file is coming into my folder. I have problems if a new column is added in my source CSV, especially when it is not located at the end ...
HotChilli
Community Champion
Community ChampionThere is a parameter in Csv.Document which is for the number of columns (this is probably the Source step in Power Query). You can remove this parameter.
--
You will need to think about other transforms that may break if you do this. If the rest of the transforms are simple or involve Unpivotting to cope with multiple, similar columns, it should be ok.
Hi HotChilli thanks for the fast answer.
How exactly can I remove this parameter? In my query editor, on advanced editor? I can't find Csv.document