topic Re: concatinate in QlikView

concatinate

priyarane — Tue, 24 Feb 2015 13:52:16 GMT

Hi Guys,

I have a issue with concatinate like below;

Scenario 1

Qvd1:

A,B

from Qvd1;

Concatinate(Qvd1)

load

from Qvd2;

Then I am not able to see C's data - and looks like;A,B,C
1,2,-

4,8,-

Scenario 2

Qvd2:

from Qvd2;

Concatinate(Qvd2)

load

A,B

from Qvd1;

Then I am not able to see A,B's data - and looks like;

A,B,C
-,-,Z

-,-,Y

Re: concatinate

rajeshvaswani77 — Tue, 24 Feb 2015 13:57:18 GMT

Hi,

You need to spell it as Concatenate

thanks,

Rajesh Vaswani

Re: concatinate

maxgro — Tue, 24 Feb 2015 14:00:05 GMT

try this

DIRECTORY;

Qvd1:

load * inline [

A,B

a1,b1

a2,b2

];

Qvd2:

load * inline [

];

store Qvd1 into Qvd1.qvd (qvd);

store Qvd2 into Qvd2.qvd (qvd);

DROP Tables Qvd1, Qvd2;

Qvd1:

load A,B from Qvd1.qvd (qvd);

Concatenate (Qvd1)

load C from Qvd2.qvd (qvd);

Re: concatinate

priyarane — Tue, 24 Feb 2015 14:15:49 GMT

Still not coming,

TradeDetailForecastQVD:

LOAD IDENT
FROM

(qvd);
Concatenate(TradeDetailForecastQVD)

LOAD Trad_LEGAL_ENTITY,
Trad_FTP_ENTITY_CODE
FROM

(qvd);

Data is there for all. Even I checked till last.

Re: concatinate

fkeuroglian — Tue, 24 Feb 2015 14:19:46 GMT

Priya, hi

the result of the print that you have is the correct,

if you concatenate two tables that any field join with other field you will see like you have now.

you have A, B from q1 and C from qv2, you concatenate and the result is ok, the data that have A and B do not have C, that is correct.

what do you want to do?

please let me know the objetive and the result you want?

Thank you Fernando

see this post that explain concatenate function

http://community.qlik.com/thread/39177

Concatenate and NoConcatenate in QlikView – Part 1 | Learn QlikView

Join and concatenate in qlikview

Re: concatinate

maxgro — Tue, 24 Feb 2015 14:47:36 GMT

post your data (qvd) or an extract of these

Re: concatinate

Tue, 24 Feb 2015 15:16:08 GMT

Hi Priya,

you just need to correct spelling.

see below.

Concatenate

Re: concatinate

Tue, 24 Feb 2015 15:19:41 GMT

could you please attach the qvw?

Re: concatinate

Anonymous — Tue, 24 Feb 2015 15:31:39 GMT

like Fernando mentioned, the result is correct. if you scroll down enough, you will see the values from other tables as well. but the corresponding fields from the other table will be null as there is no key to associate the two tables data with.

Re: concatinate

Wed, 25 Feb 2015 08:18:02 GMT

Concatenate appends the rows of one table to another. Concatenate never merges any rows. The number of rows in a concatenated table is always the sum of the rows from the two input tables

There has to be a key in order to see the combine results (A being the key in this)

Qvd1:

A,B

from Qvd1;

Concatinate(Qvd1)

load

A,C

from Qvd2;

Re: concatinate

Anonymous — Wed, 25 Feb 2015 08:36:02 GMT

Hi Priya,

In your script couple of load's are missing and please correct concatenate keyword spelling

Try :

//Scenario 1

Qvd1:
Load A,B
from ../../Qvd1;

Concatenate
Load C
from ../../Qvd2;

//Scenario 2

Qvd2:
Load C
from ../../Qvd2;

Concatenate
Load A,B
from ../../Qvd1;

Regards

Neetha