Resident Load

sudhakar_budde — Mon, 29 Jun 2015 12:34:13 GMT

Hi,

I am new to QlikView.

I have a scenario where I have to load a table called 'Client' many times like 'Client', 'Agency', 'Contact'.

I realised I can use 'Resident' load. But quite not sure how to create keys that are relevent to the meaning of the table so that it will join to associated table.

The associated table 'Orders' has got the keys 'CLIENT_ID', 'AGENCY_ID', 'CONTACT_ID'.

And the 'Client' table has got the key is 'CL_ID'. This is joined to the above keys.

I have loaded the tables seperately without using 'Resident' and can see the data model. Reloaded successfully and data is visible.

But what is the best practice ? Can any one help me to achieve this please?

Thanks

Sudhakar

Re: Resident Load

swuehl — Mon, 29 Jun 2015 15:58:18 GMT

How does you script currently look like?

You would probably need to rename fields of your Client table other than CL_ID also to avoid a synthetic key / circular reference.

If you are loading the Client table from a QVD, I would assume that it is even better to load CLIENT, AGENCY, CONTACT directly from the QVD (and using RENAME FIELDS or AS) than doing a resident table LOAD.

topic Resident Load in QlikView

Resident Load

Re: Resident Load