Creating flags between 2 tables

[priyarane]

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;

[ariel_klien]

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;

BR 

Ariel

[#3]

Hi Priya,

find the attachment.

[sunny_talwar]

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,

S