Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
i got the solution.. adding noconcatenate keyword seems to resolve the problem.
TableThree:
NOCONCATENATE LOAD * RESIDENT TableOne;
i got the solution.. adding noconcatenate keyword seems to resolve the problem.
TableThree:
NOCONCATENATE LOAD * RESIDENT TableOne;