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.

ddpl's avatar
ddpl
Solution Sage
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.