Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Sorry, but I don't understand what you're trying to achieve.
Why not add new tables and joins, instead of doing lookups and mappings ? This will keep the original fields while adding new fields
-Alex
Can you clarify your question, maybe with an example?
I think he wants to do something like
load field1,
field2
resident table1, table2, table3
where exists(field1)
Dunno it's just my opinion.
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