Load Script: Remove rows from table A by matching the key field from table B

[stanish]

Remove rows by matching column sno in Table A and column sno in Table B and remove the duplicates 

[IamAlbinAntony]

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;