Join of table

[#1]

Hello,

I have two tables on is master table and contains so many columns and second table has same data but i want to know the records which is not present in the second table but i need to know that record like

ex:

MasterTable1:

vtc,sdc,blk

2,1,2    

3,1,3

4,2,4

5,2,5

DataTable2:

vtc,sdc,blk

2,1,2    

3,1,3

in second table last 2 record which is present in Mastertable but not in Datatable i want to get only those 2 records details like

4,2,4

5,2,5

like ways i have 5000 records, any one provide help for this

SRS

[jagannalla]

Hello,

Try this code. Hope it helps you.

DataTable2:

LOAD *,F1&F2&F3 as key;

LOAD * INLINE [

    F1, F2, F3

    2, 1, 2

    3, 1, 3

];

MasterTable1:

LOAD *,1 as CountValue

Where Not Exists(key,F1&F2&F3) ;

LOAD * INLINE [

    F1, F2, F3

    2, 1, 2

    3, 1, 3

    4, 2, 4

    5, 2, 5

];

DROP Table DataTable2;

[jagannalla · Accepted solution]

Try this

Data:

LOAD

[S NO],

sdn,

vtc,

blk,

sdc

FROM

(ooxml, embedded labels, table is Data);

Main:

LOAD [S NO],

     sdn,

     vtc,

     blk,

     sdc,1 as CountValue

FROM

(ooxml, embedded labels, table is Main)

Where Not Exists([S NO]) ;

DROP Table Data;