topic Re: Concat in QlikView

Concat

Wed, 04 Apr 2012 10:00:53 GMT

How to concat 2 cross tables????

Concat

SunilChauhan — Wed, 04 Apr 2012 10:05:14 GMT

if you load

two cross table then it will automatcally concatenated

or use

if you want then use concatenate in between two tables

Concat

vijay_iitkgp — Wed, 04 Apr 2012 11:14:54 GMT

Create both Cross Tables seperately and the concatenate it

Re: Concat

Wed, 23 Oct 2013 05:40:53 GMT

Hello Manish,

I was wondering if you've already solved the problem. I got the same problem as well. Got a few cross tables and i'm not able to concatenate them.

Re: Concat

Wed, 23 Oct 2013 07:48:56 GMT

My colleague found the answer:

Load the cross tables into another tab.

Example:

LOAD *,
'ScoreDB' AS Transactietype
Resident ScoreDB;

Concatenate(Transacties)

LOAD *,
'ScoreCrit' AS Transactietype
Resident ScoreCrit;

Concatenate (Transacties)

Drop table ScoreDB;
Drop Table ScoreCrit;

This worked for me.

Re: Concat

qlikpahadi07 — Wed, 23 Oct 2013 08:51:22 GMT

hi,

f you load two table with same structure then it will automatically concatenated

else you need to force fully concatenate like

Tab1:

Load

a,b,c

from Tab1;

Concatenate

Load

a,b

from Tab2;

Re: Concat

Wed, 23 Oct 2013 09:33:39 GMT

I tried it as well but that didn't work with cross tables. In my case it didn’t concatenate automatically. After I loaded the cross table again I was able to concatenate the tables.