Forum Discussion
T-Pan
Helper I
Helper IGet data from Folder, but excels with different column headers
Hello everyone, Every week i update an power bi report with excel files which i receive from the data department. So i dicided to try to import the data from "Folder". The excel files have the sa...
Hi T-Pan ,
Please try this way.
I will show you my sample data first:
Then, I do the append query first:
The results are as follows:Then do a column merge:
Click both column "Date_2023" and column "Date_2024":The final results are as follows:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
spinfuzer
Solution Sage
Solution SageMaybe in the Transform Sample File Use Headers as First Row (or whatever you need to do in order to make the first row(s) the same). Then in your main query (where all the files are combined) fix the headers from there.