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/CollectCombin...
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/