Extract different labels by category in one reference table

Wed, 16 Jul 2014 13:44:57 GMT

I have the fact table like this

Table Orders

Things like Order type or Customer type is stored in one table Parameter, by Category and in different language as following

I would like to obtain the description (label) in the interface according to the application language (via a variable)

As far as I see:

- ApplyMap is quick, but it will increase the size of my fact table

- LOAD table Parameter and create link to the fact table, I have more than 10 fields that I would like to extract the description !

What is the best practice to handle such situation ?

Thank you

topic Extract different labels by category in one reference table in QlikView