topic Re: Reference data in a different table (Load Script) in QlikView

Reference data in a different table (Load Script)

Dayna — Thu, 24 Sep 2015 09:43:43 GMT

Hello All,

In the past I've used some QlikView functionality where you're able to reference data in a different table within the load script.. For the life of me I can't remember what it's called though!

The function worked where you would load data into a table as normal, then in another table you could reference that data, i.e. by bringing in a field where data matched.

I hope that makes sense, and I hope you can help me!

Kind Regards,

Dayna

Re: Reference data in a different table (Load Script)

SreeniJD — Thu, 24 Sep 2015 09:46:10 GMT

Hi Dayna,

Its mapping table where you can lookup for the references. This table should have a maximum of 2 columns, one is primarily the column you are looking and the second one is obviously the value you want to bring in.

let me know your scenario,where exactly you need the help.

Happy to help

Sreeni

Re: Reference data in a different table (Load Script)

swuehl — Thu, 24 Sep 2015 09:46:57 GMT

Maybe you want to lookup LookUp() in the HELP?

Re: Reference data in a different table (Load Script)

Dayna — Thu, 24 Sep 2015 09:54:27 GMT

Sreeni,

That's the one, thank you! I'll have to make a note of it somewhere for future reference...!!

My issue is related to another thread I've added here where I'm having optimization and lengthy reloads when trying to do firstsortedvalue in the load script on a large table.

My idea is to get the ID that I want the value for; then use the mapping table to filter it. Not sure if that's the best way but going to give it a go!

Here's the thread, I'd greatly receive any assistance you could provide...

FirstSortedValue Load Script Optimization

Kind Regards,

Dayna