Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

  • trebgatte's avatar
    trebgatte
    Most Valuable Professional
    5 years ago

    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