
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
NoConcatenate CrossTable
My crosstable (Table2) gets concatenated to another table (Table1) that has been loaded earlier in the script. I first need to transform Table2 before it gets concatenated to Table1. It is not possible to use the "NoConcatenate Load" statement within the CrossTable function as this results in an "illegal prefix" error. I am able to solve this issue by using the script in blue, however, my QVDs are large, so this is not efficient. Is there any way to force the CrossTable not to concatenate? My script:
Table1:
NoConcatenate Load
%email_id
%interest_id
interest_active
From ... (qvd);
Store Table1 into [LIB://...];
Drop Table Table1;
//Table2 results in the same field names as Table1
Table2:
CrossTable(%interest_id, interest_active)
Load
*
Resident Member_Interests_tmp1;
Table2_tmp:
NoConcatenate Load
%email_id
%interest_id,
interest_active,
ApplyMap('maptable',%interest_id,'N/A') as interest_name
Resident Table2; //<<< Table not found
Drop Table2;
Table1: NoConcatenate Load * From [LIB://...] (qvd);
Concatenate(Table1) Load * Resident Table2_tmp;
Drop Table Table2_tmp;
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What about adding an extra field with an arbitrary value to the first or second table and then drop it at the end of the script?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What about adding an extra field with an arbitrary value to the first or second table and then drop it at the end of the script?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, try to do preceding load, like this:
//Table2 results in the same field names as Table1
Table2:
Load *;
CrossTable(%interest_id, interest_active)
Load
*
Resident Member_Interests_tmp1;
it worked for me
