Flag creation help

[mahitham]

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

[francescoreggia · Accepted solution]

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;

[sunny_talwar]

Here is another option

Table2:

LOAD [Employee ID],

     [Employee Name],

     Startdate

     EndDate

     Email

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