Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
zenjah
Contributor
Contributor

CrossTable and Concatenate

Hi - sorry I know this topic has been posted before but I couldn't understand the solutions posted in this forum and am wondering if anyone can help clarify? Thanks

I am trying to do something like this which gives me an error message because apparently, we can't concatenate 2 cross tables together. 

Test:
CROSSTABLE(Category, Numerator, 4)
LOAD
...
FROM [...]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);

CONCATENATE(Test)
CROSSTABLE(Category, Numerator, 4)
LOAD
'...
FROM [...]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq)
;

I know in other posts, they talked about LOAD * RESIDENT ... and DROP TABLE ... but I can't get the syntax right - any help is greatly appreciated.

Labels (3)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

CTable1:
Crosstable (....
...;

CTable2:
Crosstable (....
...;
NoConcatenate
Final:
Load * resident CTable1;
Concatenate
Load * resident CTable2;

Drop Tables CTable1, CTable2;

View solution in original post

3 Replies
Lisa_P
Employee
Employee

If all the fields are the same, you won't need the Concatenate prefix, it should autoConcatenate

tresesco
MVP
MVP

Try like:

CTable1:
Crosstable (....
...;

CTable2:
Crosstable (....
...;
NoConcatenate
Final:
Load * resident CTable1;
Concatenate
Load * resident CTable2;

Drop Tables CTable1, CTable2;

View solution in original post

zenjah
Contributor
Contributor
Author

great thanks!