Discussion board where members can get started with Qlik Sense.
Can any one please help me on below requirement.
I have Two Tables Table1 and Table 2 like below with the below data
Here need to compare Table 1 ID with Table 2 ID.If Table1 ID exists in Table 2 then Status is Yes else No.
Please help me to do in backend.
Thanks in advance
Go to Solution.
Employee ID ,
'Yes' as Status
ApplyMap('TableMap',[Employee ID],'No') as Status,
Here is another option
LOAD [Employee ID],
If(Exists([Employee ID]), 'Yes', 'No') as Status
This is assuming that Table1 will have all the Employee ID, and Table 2 will have subset of Employee ID from Table 1