Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Combining 2 tables without matching rows

Hello, is it possible to combine 2 tables some column match but some aren't match without any matching rows. Just wanted to make this 2 dataset saved as 1 table?   Here's the column for my 1st data...
Need Help
Show and Tell
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi Anonymous ,

     

    Table1:

     

    Table2:

     

    Please try following measure to create a new table to combine two tables:

    Table = UNION(
    SELECTCOLUMNS('Table1',"Column1",'Table1'[Column1],"Column2",'Table1'[Column2]),
    SELECTCOLUMNS('Table2',"Column1",'Table2'[Column1],"Column2",'Table2'[Column2])
)

     

    Is this the result you want?

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yadongf-msft's avatar
v-yadongf-msft
Community Support
3 years ago

Hi Anonymous ,

 

Table1:

 

Table2:

 

Please try following measure to create a new table to combine two tables:

Table = UNION(
    SELECTCOLUMNS('Table1',"Column1",'Table1'[Column1],"Column2",'Table1'[Column2]),
    SELECTCOLUMNS('Table2',"Column1",'Table2'[Column1],"Column2",'Table2'[Column2])
)

 

Is this the result you want?

 

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello, tried this and works like magic! Thanks a lot!!