CODEWITHSUNDEEP
powerbipowerquery
Tan Saint
Tan Saint

Reputation: 92

PowerBI concatatenate 3 tables

I'm trying to concatenate 3 different tables in powerBI, with powerQuery but I couldn't find the solution for it. The closest I could find is appending the query, however it does not concatenate the table shown below.

Example:

concatenate table example and result

Im trying to concatenate table Code1 to Code2 to Code3 (bottom 3 tables) to look like the top one.

Thank you very much for your help

Upvotes: 0

Views: 102

Answers (2)

horseyride
horseyride

Reputation: 21298

Alternate method

In Table3, add column, custom column,

= Table1

then expand

Add column, custom column

= Table2

then expand

Upvotes: 1

Jody Highroller
Jody Highroller

Reputation: 1029

Add a custom column to each of your queries, all with the same value. For my test I just used the value of 1.

enter image description here

Then merge Query 1 to Query 2 on your custom column. Next, merge that query to Query 3 again on the custom column. Once you rearrange the columns you will get an output that looks like this:

enter image description here

Upvotes: 0

Related Questions