Load from resident table

Thu, 07 Jul 2011 05:19:25 GMT

TableOne:
LOAD * INLINE [
ID, Date1, Value
1, 01/01/2011, 10
];

TableTwo:
LOAD * INLINE [
ID, Details
1, Pr1
];

// TableThree not loading

TableThree:
LOAD * RESIDENT TableOne;
JOIN LOAD * RESIDENT TableTwo;

After reloading the script, when I try the table viewer (Ctrl+T), I could see only TableOne and TableTwo. TableThree is not present.

But if I change the TableThree script as below, I could see TableThree also in table viewer. Here I have removed one field form the load script.

// TableThree is loaded

TableThree:

LOAD ID, Date RESIDENT TableOne;

JOIN LOAD * RESIDENT TableTwo;

Why is it that I cannot load all the fields of TableOne in the initial LOAD statement for TableThree ?

Even if I just try to load all fields of TableOne to TableThree (by removing the join statement above) as shown below TableThree is not loaded.

// TableThree not loading

TableThree:

LOAD * RESIDENT TableOne;

Is there any reson for this behavior or soultion ?

Thu, 07 Jul 2011 06:15:19 GMT

i got the solution.. adding noconcatenate keyword seems to resolve the problem.

TableThree:

NOCONCATENATE LOAD * RESIDENT TableOne;

topic Load from resident table in QlikView