NoConcatenate CrossTable

[TimvB]

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;

[lorenzoconforti · Accepted solution]

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?

[pkucharski]

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