Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
mendoncart
Not applicable

How to concatenate after joining?

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

1 Solution

Accepted Solutions
CarlosAMonroy
Not applicable

Re: How to concatenate after joining?

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

3 Replies
CarlosAMonroy
Not applicable

Re: How to concatenate after joining?

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

mendoncart
Not applicable

Re: How to concatenate after joining?

Hey Carlos,

It worked fine!

Thank you so much for your support and your time!

Have a wonderful week!

richard_cook
Not applicable

Re: How to concatenate after joining?

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