topic Re: Concatenate and Left join at same time in QlikView

Concatenate and Left join at same time

Thu, 17 Aug 2017 12:43:56 GMT

Hi,

I am trying to use Concatenate and Left Join together.

Below is the Current query:

Load

x,y,z

from Table1;

Concatenate

Load

x,y,z

Resident Table2;

Now I want to Left Join on Table2 with Table 3

Load

x,y,z

from Table1;

Concatenate

Load

Resident Table 3

Left Join (B)

Load

x,y,z

Resident Table2;

--Gives an error Cannot find table Left Join (B);

Please let me know how to use Concatenate and Left join in the query.

Re: Concatenate and Left join at same time

felipedl — Thu, 17 Aug 2017 12:52:16 GMT

Hi Deepika,

When you concatenate tables and load them at the same time, it doesn't matter that you named it, it wont store as a different table

Do this to get the tables.

Load

x,y,z

from Table1;

Load

Resident Table 3

Concatenate(A)

Load

Resident B;

This way, you'll have the table B loaded, which will be concatenated afterwards to A.

Re: Concatenate and Left join at same time

tresB — Thu, 17 Aug 2017 12:55:45 GMT

It's top-down execution. Table B doesn't exist since that has already been concatenated with A. Try like:

Load

Resident Table 3

Left Join (B)

Load

x,y,z

Resident Table2;

Concatenate

Load

x,y,z

from Table1;

Re: Concatenate and Left join at same time

Thu, 17 Aug 2017 12:56:28 GMT

Thank you Felip for your quick reply.

I am trying to load

Table B into table A

But there is Left join on Table B with Table2 as I want to considered all records from Table2.

Re: Concatenate and Left join at same time

d_prashanthredd — Thu, 17 Aug 2017 13:12:03 GMT

Hi have a loook at below script and also attached qvf file

Table3:

load * Inline [

];

Left Join (Table3)

Table2:

load * Inline [

X,Y,Z

2,b,b2

3,c,c3

4,d,d4

];

NoConcatenate

Load * Resident Table3;

drop Table Table3;

Concatenate

Table1:

load * Inline [

X,Y,Z

1,a,a1

2,b,b2

3,c,c3

];