Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
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
TableMap:
Mapping load
Employee ID ,
'Yes' as Status
from Table2;
Table1:
Load
ApplyMap('TableMap',[Employee ID],'No') as Status,
[Employee ID],
[Employee Name],
Startdate
EndDate
Company
From Table1;
TableMap:
Mapping load
Employee ID ,
'Yes' as Status
from Table2;
Table1:
Load
ApplyMap('TableMap',[Employee ID],'No') as Status,
[Employee ID],
[Employee Name],
Startdate
EndDate
Company
From Table1;
Here is another option
Table2:
LOAD [Employee ID],
[Employee Name],
Startdate
EndDate
From.....
Table1:
LOAD [Employee ID],
[Employee Name],
Startdate
EndDate
Company,
If(Exists([Employee ID]), 'Yes', 'No') as Status
From.....
This is assuming that Table1 will have all the Employee ID, and Table 2 will have subset of Employee ID from Table 1