Forum Discussion
Combine CSV files in folder with different column counts
I am using power query to import multiple CSV files from SharePoint document. But, my files contain a different count of columns: Most files: Column A Column B Column C Column D Column E Co...
Hi Aidan_Wang ,
It's the Transform From Sample File query that you will need to edit. The code you've provided is for the output query after the sample transformations have been completed.
You should see a helper query folder in your queries list that contains the query I've mentioned above.
Pete