2 tables merged

[ask]

Hi team,

I have 2 table source to merge. First table contains full name, Second table contains first name, last name.

Full Name, and First Name +Last Name are supposed to be the key to join  I create a column as Full name in second table. But I go to edit queries -- merge queries,  the full name in the second table which I create to combine first name and last name will not shown in the second table. So, how to join 2 tables? Thanks.

[dkay84_PowerBI · Accepted solution]

Did you create the full name column using DAX?  Calc columns will not appear in the query editor, so I suggest that you create your calc column there.  Then you should see it as an available choice for the merge.

However, as a best practice, it will be much better performance (depending on how big your table is) if you join tables based on an integer key vs. string key.  Just letting you know to think ahead for production level workloads.  This may not be applicable so please ignore me if that is the case 

[dkay84_PowerBI · Accepted solution]

Did you create the full name column using DAX?  Calc columns will not appear in the query editor, so I suggest that you create your calc column there.  Then you should see it as an available choice for the merge.

However, as a best practice, it will be much better performance (depending on how big your table is) if you join tables based on an integer key vs. string key.  Just letting you know to think ahead for production level workloads.  This may not be applicable so please ignore me if that is the case 

[ask]

Thanks. 

[v-huizhn-msft · Accepted solution]

Hi @ask,

Have you resolved your issue? You want to get a new column including First Name +Last Name. You should select the two columns, right click->Merge columns(please see the first screenshot), select the separater(please see the second screenshot). 



Then you can merge the two table using the full name column in first table and the new column.

Best Regards,
Angelia