Load an outer excluding join with two tables

[seband_fredes]

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

T1:

Eq	Cash
1	10
2	50
3	20

T2:

Eq	Cash
1	80
2	50
3	30
6	90
7	75

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

T3:

Eq	Cash
1	10
2	50
3	20
6	90
7	75

Any solution?.

Thanks for all.

Blessing

[Vegar · Accepted solution]

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 · Accepted solution]

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

1:

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);