Reference data in a different table (Load Script)

[Dayna]

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

[SreeniJD · Accepted solution]

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

[swuehl]

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

[Dayna]

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