Merge 3 or more power queries

[shophoney]

Hi,

I'm looking for a way to MERGE 3 or more power queries. I can append them but would like them side by side.

Is there a way?

Thanks

 

[XL Pro]

If the tables have different column names, it can be done.
Here is one way to do it.

let
    Table1 = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclRwSSxJVNJRcoIxnCGM2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [A = _t, B = _t, C = _t]),
    Table2 = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclFwSSxJVNJRcoUx3CCM2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [D = _t, E = _t, F = _t]),
    Table3 = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcldwSSxJVNJR8oAxPCGM2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [G = _t, H = _t, I = _t]),
    SideBySide = Table.FromColumns(Table.ToColumns(Table1) & Table.ToColumns(Table2) & Table.ToColumns(Table3), Table.ColumnNames(Table1) & Table.ColumnNames(Table2) & Table.ColumnNames(Table3))
in
    SideBySide

 

[shophoney]

Hi,

Thanks for the reply.

I'm not sure i completely follow.

I tried the following:
let
TB_0000_LAST_QTR = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclRwSSxJVNJRcoIxnCGM2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [A = _t, B = _t, C = _t]),
TB_MENU_LAST_QTR = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclFwSSxJVNJRcoUx3CCM2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [D = _t, E = _t, F = _t]),
TB_AVER_LAST_QTR = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcldwSSxJVNJR8oAxPCGM2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [G = _t, H = _t, I = _t]),
SideBySide = Table.FromColumns(Table.ToColumns(TB_0000_LAST_QTR) & Table.ToColumns(TB_MENU_LAST_QTR) & Table.ToColumns(TB_AVER_LAST_QTR), Table.ColumnNames(TB_0000_LAST_QTR) & Table.ColumnNames(TB_MENU_LAST_QTR) & Table.ColumnNames(TB_AVER_LAST_QTR))
in
SideBySide


This 3 Power Queries have the same columns names. ACCOUNT NAME, AMOUNT, ACCT# and AMOUNT

 

[XL Pro]

A column name can only appear once in a table, so if you want them "side by side" in a query, you'll have to rename the columns in your appended tables.