How to use Power Query to Combine Multiple Files that have different headings

When using Power Query to Combine Files from a folder there is a problem that only the 1st file's headings are used in the output. If a later file has a new heading it won't appear.

1 line of code courtesy of Gil Ravi fixes this

= List.Union (List.Transform( PreExpand[Transform File], each Table.ColumnNames(_)) )

Here's Gil's post on this
https://datachant.com/2017/02/07/powe...


And a post relating to changing column types without referencing column names:
https://datachant.com/2016/10/07/robu...

Gil's book: https://www.amazon.com/Collect-Combin...


Download the files:
https://aasolutions.sharepoint.com/:f...


Good option suggested from Muneer Marzouq on LinkedIn is that after drilling down you could just wrap the formula in Table.Combine( ) . The downside is you lose the source file names - the upside is it's easier to remember 😁


Connect with me
https://wyn.bio.link
https://accessanalytic.com.au/