Qlik Community

App Development

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

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mendoncart
Contributor III
Contributor III

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
Creator III
Creator III

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

View solution in original post

3 Replies
CarlosAMonroy
Creator III
Creator III

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
Contributor III
Contributor III
Author

Hey Carlos,

It worked fine!

Thank you so much for your support and your time!

Have a wonderful week!

richard_cook
Contributor II
Contributor II

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