Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi experts
I have various files in a folder
- From 1 to 9 columns, header are the same in every file
- From 10 to N columns, headers are differente, containng data
How can I merge those files?
Thank you very much
Rbn
Solved! Go to Solution.
Hi @Reuben
I've adjusted the query to append many files, all you need to do is adjust the folder path in folderFileList > source step and all should work.
Please see the attached file.
Hi @Reuben
Please see the solution on the attached.
All I've done is.
Hi @Mariusz , thank you very much for your answer. From what I understood, you uploaded each table and the you go into each table and you unpitvot it.
It is very usefuell when there is only few tables to append. But in my case I have like 30 files that I need to merge... May be it is not vey "productive" to unpivot each table. I don´t know if there is another solution...
thanks again for your help
Hi @Reuben
I've adjusted the query to append many files, all you need to do is adjust the folder path in folderFileList > source step and all should work.
Please see the attached file.