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
[ Ссылка ]


And a post relating to changing column types without referencing column names:
[ Ссылка ]

Gil's book: [ Ссылка ]


Download the files:
[ Ссылка ]


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
[ Ссылка ]
[ Ссылка ]

свернуть