Forum Discussion

lornafnb's avatar
lornafnb
Helper I
4 years ago
Solved

Create relationship between 2 queries and identify nulls

hi all,   I have 2 data sets - my "main" data set called Friends :   Friends Surname John White Joe Black Mary Simmonds   and the second one is Friends Birthdays: (note their...
Need Help
  • ddpl's avatar
    ddpl
    4 years ago

    Hi,

     

    If you dont want to create calculated or custom column then you can replace null value with "No Corresponding record found" after merging the table.

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Use this code in a custom column

= try #"Friends Birthdays"{[Friends=[Friends]]}[Birthday] otherwise "No Corresponding record found"