Resident Loads

[#1]

Has anyone tried a resident load from multiple tables?

I need to create look ups to existing fields but need to do a "load as" while also maintaining their original name.

Any ideas?

[danielrozental]

Sorry, but I don't understand what you're trying to achieve.

[#3]

Why not add new tables and joins,  instead of doing lookups and mappings ? This will keep the original fields while adding new fields

-Alex

[Michiel_QV_Fan]

Can you clarify your question, maybe with an example?

[#5]

I think he wants to do something like

load field1,

       field2

resident table1, table2, table3

where exists(field1)

Dunno it's just my opinion.

[prieper]

Something like the below should do it:

LOAD Field1, Field2, Filename() AS Source FROM ....;

LOAD Field1, Field2, Filename() AS Source FROM ....;

....

If the Fieldnames are not always the same, you may add a NOCONCATENATE before the second (and third ...) LOAD-command.

HTH
Peter