Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
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;