Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Concat

How to concat 2 cross tables????

6 Replies
chauhans85
Esteemed Contributor

Concat

if you load

two cross table then it will automatcally concatenated

or use

if you want then use concatenate in between two tables

vijay_iitkgp
Valued Contributor

Concat

Create both Cross Tables seperately and the concatenate it

Not applicable

Re: Concat

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.

Not applicable

Re: Concat

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.

qlikpahadi07
Valued Contributor

Re: Concat

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;

Not applicable

Re: Concat

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.

Community Browser