topic Re: No Concatenate in QlikView

No Concatenate

markgraham123 — Thu, 13 Aug 2015 19:20:09 GMT

Hi all,

I have a doubt to get clarified

Am i on the right track using "No Concatenate".?????

Load A, B from xyz;

No Concatenate

Load A, B from abc;

No Concatenate

Load * Resident 1;

Outer Join

Load * Resident 2;

Drop Tables 1,2;

Re: No Concatenate

Thu, 13 Aug 2015 19:25:32 GMT

Try like below:

Load A, B from xyz;

NoConcatenate

Load A, B from abc;

NoConcatenate

Load * Resident 1;

Outer Join(3)

Load * Resident 2;

Drop Tables 1,2;

Re: No Concatenate

markgraham123 — Thu, 13 Aug 2015 19:35:01 GMT

Does that make any difference??

Please let me know as i'm a new learner.

Re: No Concatenate

Thu, 13 Aug 2015 19:41:31 GMT

I don't think so.

What o/p you are expecting ?

Re: No Concatenate

Thu, 13 Aug 2015 19:42:14 GMT

I write like that way its more readable to others & what i am trying.

Re: No Concatenate

Qrishna — Thu, 13 Aug 2015 19:44:48 GMT

Load A, B from xyz;

No Concatenate

Load A, B from abc;

No Concatenate

Load * Resident 1;

Outer Join

Load * Resident 2;

Drop Tables 1,2;

Load A, B from xyz;

No Concatenate

Load A, B from abc;

No Concatenate

Load * Resident 1;

Outer Join

Load * Resident 2;

Drop Tables 1,2;

are same.

its the readability difference.Thats all.

Re: No Concatenate

markgraham123 — Thu, 13 Aug 2015 19:45:26 GMT

Table 1 contains 2014 data and

Table 2 contains 2015 data.

I wanna join both.

In the end, can i please know how can i count total num. of lines in our app.

Re: No Concatenate

markgraham123 — Thu, 13 Aug 2015 19:46:40 GMT

Table 1 contains 2014 data and

Table 2 contains 2015 data.

So, i wanna join both to get single qvd of two years.

Am i on right track?

Re: No Concatenate

Qrishna — Thu, 13 Aug 2015 19:48:01 GMT

Do you want to join or concatenate 2015 data t0 2014 data?

if both tables have same fields then you could easily concatenate.

Re: No Concatenate

Thu, 13 Aug 2015 19:51:57 GMT

Simply remove the Concatenate in your script. So two tables auto concatenated and you can select either 2014 or 2015.

Concatenate is equal to UNION operator in SQL

Re: No Concatenate

Thu, 13 Aug 2015 19:53:03 GMT

Data granularity point of view, you need to combine the data.

Re: No Concatenate

markgraham123 — Thu, 13 Aug 2015 19:53:30 GMT

Perfect dathu.

I'm trying that now.

Re: No Concatenate

Qrishna — Thu, 13 Aug 2015 19:57:19 GMT

//-------------------------------------//

//if both tables has same field names and same number of fields or different field names//

load * inline [

A,B

1,10

2,20

3,30

];

NoConcatenate

load * inline [

A,B

4,40

5,50

6,60

];

NoConcatenate

Load * Resident 1;

Outer Join

Load * Resident 2;

Drop Tables 1,2;

store 3 into 3.qvd(qvd);

drop table 3;

//-------------------------------------//

//if both tables has same field names and same number of fields//

load * inline [

A,B

1,10

2,20

3,30

];

//concatenate //can use concatenate or just leave it alone//

load * inline [

A,B

4,40

5,50

6,60

];

store 1 into 1.qvd(qvd);

drop table 1;

//-------------------------------------//

try above.

Re: No Concatenate

jonas_rezende — Thu, 13 Aug 2015 20:00:43 GMT

Hi, Mark Graham.

Already that objective is tables join, I would suggest make direct the outer join. For example:

Table1:

Load

from xyz;

Outer Join (Table1)

Table2:

Load

from abc;

I would use the NoConcatenate this example:

Table1_tmp:

Load

#Quantity

from xyz;

Outer Join (Table1_tmp)

Table2:

Load

#Quantity

from abc;

NoConcatenate

Table1:

Load

if(#Quantity < 0,0, #Quantity) As#Quantity //Here the condition involves the entire table.

Resident Table1_tmp;

Drop table Table1_tmp;

Hope this helps!

Re: No Concatenate

Thu, 13 Aug 2015 20:01:29 GMT

If you get the answer please mark thread as answered.

Re: No Concatenate

alis2063 — Tue, 16 Jan 2018 19:06:38 GMT

Yes it is but if we have different field name then it would be considered new field in case of sql union we both both table should have no. of supplied fields would be same