How to Load and Resident from Two Tables

[#1]

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

[fernandotoledo]

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

[johnw]

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]

Perfect!

[#5]

Thank you so much

[#6]

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