QlikSense

[govardhana_r]

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

Email	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

[Mark_Little · Accepted solution]

HI @govardhana_r 

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'