cancel
Showing results for 
Search instead for 
Did you mean: 
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
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Kudoed Authors