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
gv445
Frequent Visitor

How to append two or mote tables from list

Hi folks,

 

I am trying to append 2 or more Excel tables from folder. I arrive at this point in my Power Query procedure:

 

Capture.PNG

 

I know I can click on diverting Expand arrows and get the job done. My problem though is that my tables contain varying number of columns. The columns also might appear with different names. I want all the columns and their names from all the tables be present. Therefore I am using Append to obtain combined table with all the column names in place. The following command works fine

 

Table.Combine(test[Transform File])

 

but I am loosing column Date modified. Is there a way to append these tables and keep Date modified column in place?

Would be most grateful for any hints.

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

NewStep=Table.FromPartitions("Date modified",Table.ToRows(PreviousStepName))

View solution in original post

2 REPLIES 2
gv445
Frequent Visitor

Great. Thank you very much !

wdx223_Daniel
Super User
Super User

NewStep=Table.FromPartitions("Date modified",Table.ToRows(PreviousStepName))

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