Concat

[#1]

How to concat 2 cross tables????

[SunilChauhan]

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]

Create both Cross Tables seperately and the concatenate it

[#4]

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.

[#5]

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]

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;

[#7]

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.