merge tables in a folder with different columns

[Anonymous]

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

File2

File1

How can I merge those files?

Thank you very much

Rbn

[Mariusz]

Hi @Anonymous 

Please see the solution on the attached.

All I've done is.

1. Unpivoted Date Columns in both files.
2. 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.

[Anonymous]

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 · Accepted solution]

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.

[Anonymous]

Thanks @Mariusz ! Great job!