Forum Discussion

soedholm's avatar
soedholm
Regular Visitor
9 years ago
Solved

match string values in two diffrent tables

Hi,   I have two tables what each have a column for email. I'd like to "match" the emails to get country value from the second table into the first. Situation is:   Table A: email1   Table B: ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    hi soedholm

     

    Go to Edit Query -- Merge Query

     

    +

     

    Step 2: Click on expand

     

     

    The result is 

     

  • soedholm's avatar
    soedholm
    9 years ago

    Thanks!!!!

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    soedholm

     

    You can also use DAX to achieve your goal. Just add the calculated column in table A and use LOOKUPVALUE() to get the country column.

     

    Country Column = LOOKUPVALUE(TableB[Country],TableA[Email1],TableB[Email2])

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

soedholm

 

You can also use DAX to achieve your goal. Just add the calculated column in table A and use LOOKUPVALUE() to get the country column.

 

Country Column = LOOKUPVALUE(TableB[Country],TableA[Email1],TableB[Email2])

 

Regards,