Forum Discussion

RandomKitten's avatar
RandomKitten
Frequent Visitor
7 years ago

Match one column OR another to a different table

Basically, I have a table with data in two columns that I need to match to another table. The problem is, I need to conditionally match this table to another based on whether a column has data.   T...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi RandomKitten 

You may try to add a column in table1 to check if it match or not.

Column =
IF (
    Table1[Device Code] <> BLANK (),
    IF (
        Table1[Device Code] IN VALUES ( Table2[Code] )
            || Table1[Device Name] IN VALUES ( Table2[Product] ),
        "Match",
        "Not match"
    )
)

Regards,

RandomKitten's avatar
RandomKitten
Frequent Visitor
7 years ago

Thank you, v-cherch-msft.  However, the point of this is not to confirm whether a match exists, but to build a table relationship based on the match.  I apologize if I was unclear on this. 

 

Creating a "Match/No Match" column will not give me the link I need to establish a relationship to the other table so I can pull device information based on the product.