CrossTable and Concatenate

[Anonymous]

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.

[Lisa_P]

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

[tresesco · Accepted solution]

Try like:

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

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

Drop Tables CTable1, CTable2;

[Anonymous]

great thanks!

[niranjana]

Hi,

I tried your logic , but it shows error as "Second table not found".

My situation is same your descriptoin above

Thanks