Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Reuben
Helper III
Helper III

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

File2

File1

How can I merge those files?

 

Thank you very much

Rbn

 

 

1 ACCEPTED SOLUTION
Mariusz
Community Champion
Community Champion

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.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

View solution in original post

4 REPLIES 4
Mariusz
Community Champion
Community Champion

Hi @Reuben 

 

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.
Mariusz Repczynski

 

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
Community Champion
Community Champion

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.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

Thanks @Mariusz ! Great job!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors