Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concat

How to concat 2 cross tables????

6 Replies
IamBack
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.