Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Remove rows by matching column sno in Table A and column sno in Table B and remove the duplicates
TableA:
LOAD
sno,
qty As A.qty,
"date" As A.Date
FROM [lib://DataFiles/TableA.xlsx]
(ooxml, embedded labels, table is Sheet1);
Join (TableA)
// TableB:
LOAD
sno,
qty As B.qty,
"date" As B.Date
FROM [lib://DataFiles/TableB.xlsx]
(ooxml, embedded labels, table is Sheet1);
Table:
Load
sno,
RangeSum(B.qty)-RangeSum(A.qty) As qty,
A.Date,
B.Date
Resident TableA;
Drop Table TableA;