Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stanish
Contributor II
Contributor II

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

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

Labels (4)
1 Reply
FruzoCrew
Creator
Creator

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;