Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi folks,
I am trying to append 2 or more Excel tables from folder. I arrive at this point in my Power Query procedure:
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.
Solved! Go to Solution.
NewStep=Table.FromPartitions("Date modified",Table.ToRows(PreviousStepName))
Great. Thank you very much !
NewStep=Table.FromPartitions("Date modified",Table.ToRows(PreviousStepName))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
39 | |
26 | |
22 | |
21 | |
16 |