Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys! I need some help from you.
I have 4 tables, and i'm joining them in pairs, and I need to concatenate one pair with the other.
Is something like this:
Table1A
Load
....
From X
Left join (Table1A)
Table2A
Load
....
From X
Table1B
Load
....
From X
Left Join (Table1B)
Table2B
Load
....
From X
Now I want to concatenate the joined Table1B with Table1A and make just one table.
If I use the concatenate between Table2A and Table1B the Left Join (Table1B) command is not executed because Table1B is concatenated with Table1A.
Any thoughts?
Thanks
Hi Ruytter,
What you can do is the following:
After joining the tables. Do this:
NoConcatenate
Table1A_1B:
Load *
Resident Table1A;
concatenate (Table1A_1B)
Load *
Resident Table1B;
drop Tables Table1A, Table1B;
Hope that helps,
Carlos M
Hi Ruytter,
What you can do is the following:
After joining the tables. Do this:
NoConcatenate
Table1A_1B:
Load *
Resident Table1A;
concatenate (Table1A_1B)
Load *
Resident Table1B;
drop Tables Table1A, Table1B;
Hope that helps,
Carlos M
Hey Carlos,
It worked fine!
Thank you so much for your support and your time!
Have a wonderful week!
This solution helped me as well. Thanks for posting it!