Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load from resident table

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 ?

1 Solution

Accepted Solutions
Not applicable
Author

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

TableThree:

NOCONCATENATE LOAD * RESIDENT TableOne;

View solution in original post

1 Reply
Not applicable
Author

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

TableThree:

NOCONCATENATE LOAD * RESIDENT TableOne;