topic Re: Creating flags between 2 tables in QlikView

Creating flags between 2 tables

priyarane — Tue, 24 Feb 2015 13:41:29 GMT

Hi,

I have two tables and comparing both I need to create flags, Like

Qvd1:

Column1,Column2;

Qvd2:

Column3,Column4;

Qvd3:

if(Qvd1.Column1=Qvd2.Column2,'n','y') as Test_Flag;

Re: Creating flags between 2 tables

ariel_klien — Tue, 24 Feb 2015 14:49:27 GMT

Hi,

You can try Join the 2 tables:

Table:

load Column1,

Column2

from Qvd1

join

load Column3 as Column1,

Column3,

Column4

from Qvd2;

FlagTable:

load *,

if(Column1=Column3,'n','y') as Test_Flag

resident Table;

Drop table Table;

Ariel

Re: Creating flags between 2 tables

Tue, 24 Feb 2015 16:26:18 GMT

Hi Priya,

find the attachment.

Re: Creating flags between 2 tables

sunny_talwar — Tue, 24 Feb 2015 17:40:16 GMT

You can try this in addition to Ariel.klien answer

Table1:

LOAD [Column 1],

[Column 2]

FROM QVD1.qvd;

Table2:

LOAD [Column 3],

[Column 4],

FROM QVD2.qvd;

Join (Table2)

LOAD [Column 3],

1 as Flag

Resident Table2

Where Exists([Column 1], [Column 3]);

HTH

Best,