topic Join of table in QlikView

Join of table

Fri, 11 May 2012 13:05:42 GMT

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

Join of table

jagannalla — Fri, 11 May 2012 13:29:24 GMT

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;

Join of table

jagannalla — Fri, 11 May 2012 14:02:48 GMT

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;