topic Re: Load an outer excluding join with two tables in QlikView

Load an outer excluding join with two tables

seband_fredes — Wed, 30 Sep 2020 02:12:40 GMT

Hi everyone, I'm trying to join two tables:

T1:

T2:

I need to join this tables and the result that I need is:

T3:

Any solution?.

Thanks for all.

Blessing

Vegar — Wed, 30 Sep 2020 04:45:42 GMT

Maybe youcan use applymap for this?

CashMap:

Mapping Load Eq, Cash

From T1Source;

T3:

LOAD Eq,

Applymap('CashMap', Eq, Cash) as Cash

From T2Source;

ramchalla — Wed, 30 Sep 2020 05:04:02 GMT

@seband_fredes you can achieve this by using the keywords Not Exists. Please see the below code if it helps

Load * Inline [

A,B
1,10
2,50
3,20

];

Concatenate
2:

Load * Inline [

A,B
1,80
2,50
3,30
6,90
7,75

]

Where not Exists(A);