Forum Discussion
Solved
More efficient multiple merge query
Hello! I'm using Powerquery to create an Excel table. I have twelve queries (each which has two columns. The left column is identical row headings for each query) . The second column of each query I want to merge into a consolidated table in Powerquery. Is there a more efficient way to write this than this: #powerquery #mergepainful multiple merges
let
source={query1,query2,query3},
custom1=Table.Transpose(Table.DemoteHeaders(Table.Combine(List.Transform(source,each Table.PromoteHeaders(Table.Transpose(_)))))
in
custom1
2 Replies
let
source={query1,query2,query3},
custom1=Table.Transpose(Table.DemoteHeaders(Table.Combine(List.Transform(source,each Table.PromoteHeaders(Table.Transpose(_)))))
in
custom1
Thank you! This runs so much more efficiently.
