Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

Flag creation help

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

1 Solution

Accepted Solutions
francescoreggia
New Contributor III

Re: Flag creation help

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;

2 Replies
francescoreggia
New Contributor III

Re: Flag creation help

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;

MVP
MVP

Re: Flag creation help

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

Community Browser