Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 3 tables with Email Ids as below
Table1 | Table2 | Table3 |
abc@xyz.com;abc1@xyz.com | def@xyz.com | jkl2@xyz.com |
def@xyz.com | jkl@xyz.com;jkl2@xyz.com | abc@xyz.com |
ghi@anz.com | abc1@xyz.com | ghi@xyz.com |
Some users have 2 or more email ids and they are all the same user. I need to reconcile the tables and require the output as below. I need to create this in qliksense
Table1 | Exists in Table1 | Table2 | Exists in Table2 | Table3 | Exists in Table3 | |
abc@xyz.com;abc1@xyz.com | abc@xyz.com;abc1@xyz.com | Y | abc1@xyz.com | Y | abc@xyz.com | Y |
def@xyz.com | def@xyz.com | Y | def@xyz.com | Y | - | N |
ghi@anz.com | ghi@anz.com | Y | - | N | ghi@anz.com | Y |
jkl@xyz.com;jkl2@xyz.com | - | N | jkl@xyz.com;jkl2@xyz.com | Y | jkl2@xyz.com | Y |
first create the email table
concate the three tables and then load the distinct values. Then left join each table with 'Y' exists in table'x'
first create the email table
concate the three tables and then load the distinct values. Then left join each table with 'Y' exists in table'x'