Forum Discussion
Load data from folder multiple CSV files different schema (Power Query) - Possible?
rodneyc8063_1 , if they have nothing in common with each other, unfortunately you'll have to transform them all separately. =(
Hi hnguy71
This is definitely good to know and a neat trick!
Hm hopefully I didnt misunderstand your trick, but it sounds like "combining files within a folder" usually is for files that are like for like?
In my case for example I have a CSV file of name, then another CSV file of address, then another of telephone number etc. So each CSV file is a table in itself with unrelated columns.
I was hoping that there would be something where I could just select all the files and then let Power Query grab everything and load it all vs having to open each file and load it individually.
Not sure if something like this exists?
rodneyc8063_1 , if they have nothing in common with each other, unfortunately you'll have to transform them all separately. =(
Thanks for confirming this sad piece of news 😞
Also thank you for the neat trick, I will be sure to keep it in mind if I do need to do a mass import of similar files! 🙂