topic Resident Loads in QlikView

Resident Loads

Fri, 20 May 2011 13:00:08 GMT

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 — Fri, 20 May 2011 16:23:08 GMT

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

Mon, 23 May 2011 08:39:57 GMT

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 — Mon, 23 May 2011 09:23:50 GMT

Can you clarify your question, maybe with an example?

Mon, 23 May 2011 12:35:44 GMT

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 — Mon, 23 May 2011 14:18:33 GMT

Something like the below should do it:

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