Forum Discussion
CSV column format changed, How to adapt??
Hi I used combine function in power query to combine multiple CSV from sharepoint folder together. I used the sample file transformation - it was working like a charm untill recently - the company w...
Unfortunately this doesnt fix my issue.
Columns are still being shifted to the left and therefore will show up empty as data type dont match - which is not what I want.
I want to be able to dynamically remove those new columns.
Ah ok. I think Nate's approach should work, assuming they don't rename columns. This issue is what lead me to find the optional parameter.
You may also want to check out ImkeF blog, https://www.thebiccountant.com/ as she has a lot of great articles related to import actions like this.
Thanks!
--Treb