How to merge data

Question

Hi, I have a two datasets. I appended 'table 1' and 'table 2' below. I'm trying to merge the location data from table 2 to table 1's rows using UPPER(NTID) and EMPNET_ID as the link to show the location data.

Logic: If there is a match between those two columns, to add the location data to that row. (Sort of a XLOOKUP() you would use in excel.) How could I do that in power bi?

anonymous · Answer

Hi&nbsp;mng&nbsp;,
&nbsp;
There's a feature you can merge, please refer to
Merge queries overview - Power Query | Microsoft Learn
You can merge as follows.

Expand the tables in the Table 2 column.

&nbsp;
&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

mng · Answer

Thank you

anonymous · Answer

Hi&nbsp;mng&nbsp;,
&nbsp;
Glad to help you, please mark my reply as a solution if you can. More people will benefit, thank you.
&nbsp;
Best Regards,
Stephen Tao

Forum Discussion

How to merge data

3 Replies

Related content

Merge duplicates data in columns

MERGE QUERIES

Merge data from multiple excel files from multiple sharepoint folders

Async merge risk

Merge statement creates duplicates - Low shuffle merge as cause?