Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Load and Resident from Two Tables

How to load and resident from two tables like this.

LOAD $(myFunction(Name1, Name2))

RESIDENT Table1, Table2;

Name1 from Table1 and Name2 from Table2

Thanks & Regards,

Eddy

5 Replies
fernandotoledo
Partner - Specialist
Partner - Specialist

You should load the data into a temporary table, resident load from it, then drop it:

TMP_TABLE:

LOAD Name1 FROM TABLE1;

JOIN (TMP_TABLE) LOAD Name2 FROM TABLE2;

Final_TABLE:

LOAD Name1,Name2 RESIDENT TMP_TABLE;

DROP TMP_TABLE;

Best regards,

Fernando D´Agosto Travel

johnw
Champion III
Champion III

Or do it in place on your original table:

Table:
LOAD Name1
FROM Table1
;
JOIN Table
LOAD Name2
FROM Table2
;
LEFT JOIN Table
LOAD $(myFunction(Name1,Name2))
RESIDENT Table
;
DROP FIELDS Name1, Name2
;

fernandotoledo
Partner - Specialist
Partner - Specialist

Perfect!Beer

Not applicable
Author

Thank you so much Idea

Not applicable
Author

what does the Load(myfunction(name1,name2)) refer to?  Is it pseudo code for any function?