Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Below are the two tables
T1:
Dates, Cust
1/2/2021,A
2/3/2021,C
T2:
Date, Custs
1/2/2021,A
2/2/2021, A
3/2/2021, A
2/3/2021,A
1/2/2021,B
2/2/2021, B
3/2/2021, B
2/3/2021,B
1/2/2021,C
2/2/2021, C
3/2/2021, C
2/3/2021,C
OUTPUT
I need all the records which are not part of T1:
Date, Cust
2/2/2021, A
3/2/2021, A
2/3/2021,A
1/2/2021,B
2/2/2021, B
3/2/2021, B
2/3/2021,B
1/2/2021,C
2/2/2021, C
3/2/2021, C
please help
Hi,
Maybe by using a mapping table:
Tmap:
mapping load
Dates&'|'&Cust as Key,
1 as Map
resident T1;
OUTPUT:
Load * resident T2 where applymap('TMap',Dates&'|'&Cust,0)<>1;
Best Regards
Manuel
i m facing error
Hi
Try like below
Load Dates&'|'&Cust as Key from Table1;
Load * from Table2 where not exists(Key, Dates&'|'&Cust);
i m getting below error
Unexpected token: 'Key', expected one of: 'kml', 'biff', 'dif', 'fix', 'html', 'json', 'ooxml', ...
HI
Am not user, how you are loading the data in Qliksense.
Here, Table1 & Table 2 indicates ur source(either excel, csv, db tables) .
Hi ,
Table1 is from SQL query
table 2 is from inline load
If T2 is an inline table, try a preceeding load.
Load the Key from T1
Then following:
Load * where not exists(Key, Dates&'|'&Cust);
LOAD * INLINE [ .......