Forum Discussion
merge tables in a folder with different columns
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
Hi Anonymous
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.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
4 Replies
- Mariusz
Community Champion
Hi Anonymous
Please see the solution on the attached.
All I've done is.
- Unpivoted Date Columns in both files.
- Appended both Queries together as new
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.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
- Mariusz
Hi Anonymous
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.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.