Forum Discussion
Advocate ICannot combine CSVs due to different columns?
Hello all. I'm hoping someone can help me with a problem I've been trying to solve for a week now. What I'm am trying to do is combine multiple CSV files into a single table from SharePoint. The issue is that some of the CSVs are missing columns. This isn't an issue I can solve upstream sadly or I would do that. I do have this working in Power BI desktop; however, replicating it with a Data flow step-by-step has not worked and is giving me a missing column error (I do need the column). What I'm hoping for Power Query/Data Flow to be able to do is what panda's can do which is just fill in the missing column values with nulls where the columns don't exist.
Hi DataStraine ,
Do you want the merge to be done directly in the data flow? Can you provide me with the general structure of the table?
I have also found some similar posts, please refer to them to see if them help you.
- How can I combine different CSV files ( with different shemas ) in my dataflow creation
- Combine files with structure change
- Combining multiple csv files from folder, each with different number and/or order of columns
If what I have provided does not solve the problem for you，could you please provide the structure of each csv file that needs to be combine and the code to be applied when creating the dataflow.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
