Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concat

How to concat 2 cross tables????

6 Replies
TigerisBack
Champion
Champion

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
Partner
Partner

Create both Cross Tables seperately and the concatenate it

Not applicable
Author

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
Author

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
Specialist
Specialist

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
Author

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.