not exists records

[harsha087]

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 

[ManuelRühl]

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

[harsha087]

i m facing error 

The following error occurred:

ApplyMap error: map_id not found

The error occurred here:

t2: load Dates as Date, Custs Resident t1 where applymap('TMap',Date&'|'&Cust,0)<>1

[MayilVahanan]

Hi

Try like below

Load Dates&'|'&Cust as Key from Table1;

Load * from Table2 where not exists(Key, Dates&'|'&Cust);

[harsha087]

i m getting below error 

Unexpected token: 'Key', expected one of: 'kml', 'biff', 'dif', 'fix', 'html', 'json', 'ooxml', ...

[MayilVahanan]

HI

Am not user, how you are loading the data in Qliksense.

Here, Table1 & Table 2 indicates ur  source(either excel, csv, db tables) .

[harsha087]

Hi ,

Table1 is from SQL query 

table 2 is from inline load 

[ManuelRühl]

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 [ .......