topic Re: How to concatenate after joining? in App Development

How to concatenate after joining?

mendoncart — Mon, 27 Mar 2017 14:37:51 GMT

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

Re: How to concatenate after joining?

CarlosAMonroy — Mon, 27 Mar 2017 14:47:24 GMT

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

Re: How to concatenate after joining?

mendoncart — Mon, 27 Mar 2017 19:13:06 GMT

Hey Carlos,

It worked fine!

Thank you so much for your support and your time!

Have a wonderful week!

Re: How to concatenate after joining?

richard_cook — Fri, 15 Feb 2019 20:53:15 GMT

This solution helped me as well. Thanks for posting it!