Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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!