Forum Discussion

MrPatrick's avatar
MrPatrick
Helper I
6 years ago
Solved

Query; conditional column across tables

I have two tables table 1 "statuses" status | complete | customer_contact sale | Y | Y nosale | N | Y other | N | N table 2 "list" status | DMC sale | sale | nosale ...
Need Help
  • tex628's avatar
    tex628
    6 years ago

    Wonderful, 

    In that case keep the first column you created in the Statuses table and then create a merge between your two tables. Merge on status and then expand the column that you previously created. 

    Top right in the PowerQuery Editor

    I think this should give you the correct result, 

    / J

tex628's avatar
tex628
Community Champion
6 years ago

Are there no status duplicates in the "statuses" table?

MrPatrick's avatar
MrPatrick
Helper I
6 years ago

No, these are all unique entries.