Recently, I have been faced with a challenge of pivoting many tables. Every table was completely different, I needed some preprocessing steps, like filtering rows and so on. And I also didn’t want to...
lastUpdatedDatePublished
version
Blog Post
Great idea, but it sure seems like a lot. Couldn't you just query the source, and then use a reference query to get Table.ColumnNames? Then List.Count them for the # of columns? You could rename them by using each {ColumnName) & "", ""NewColumnName"", Dane idea for type changes.
Im not at my pc, but I'll post the code later. This can DEFINITELY be done in PQ, and without the drawbacks you mentioned!