If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
Load * resident CTable1;
Load * resident CTable2;
Drop Tables CTable1, CTable2;
View solution in original post
If all the fields are the same, you won't need the Concatenate prefix, it should autoConcatenate