Union and join tables

[#1]

Hello Guys,

I have 3 tables, A, B and C. I need to make in Load Script an union between B and C and then a join with A. how can I do?

I tried in this way (it doesn't work):

Load * from A;

inner join

temp:

Load * from B;

Concatenate(temp)

Load * from C;

Tables B and C have the same columns.

Thank you so much

[surendraj]

Load * from A;

inner join

temp:

Load * from B;

Concatenate(temp)

Load * from C

where not exists(key coloumn);

[Kushal_Chawda · Accepted solution]

try this

temp:

Load * from B;

Concatenate(temp)

Load * from C;

join(temp)

Load * from A;

you can change your join type accordingly

[pradosh_thakur]

Hi

when you joined A and B , B ceases to exist and it is now part of table A that is why concatenate didn't work

Two thing you can try

1:

temp:

Load * from B;

Concatenate(temp)

Load * from C;

join(temp)

Load * from A;

2:

try using keep and see if it works for you and suitable for your requirement

regards

Pradosh

[#5]

Thank you so much