
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try like:
CTable1: Crosstable (.... ...; CTable2: Crosstable (.... ...; NoConcatenate Final: Load * resident CTable1; Concatenate Load * resident CTable2; Drop Tables CTable1, CTable2;


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If all the fields are the same, you won't need the Concatenate prefix, it should autoConcatenate

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try like:
CTable1: Crosstable (.... ...; CTable2: Crosstable (.... ...; NoConcatenate Final: Load * resident CTable1; Concatenate Load * resident CTable2; Drop Tables CTable1, CTable2;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
great thanks!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I tried your logic , but it shows error as "Second table not found".
My situation is same your descriptoin above
Thanks
