topic Mapping load or lookup tables in QlikView

Mapping load or lookup tables

Wed, 06 Jul 2011 13:56:37 GMT

Hi Everyone,

I have a very large data set (400 variables). A lot of them are coded using numerical codes that relate to a string (not in the table). I have a data dictionary that tells me what these values relate to. I could create a lot of little tables that link to my master table for each coded variable, which is how I would normally do it for a small number of variables. Is this when I should be applying a mapping load? Would I require a map for every variable?

Thanks

Gareth

Mapping load or lookup tables

brenner_martina — Wed, 06 Jul 2011 14:02:14 GMT

Hi,

yes, working with mapping tables means for every "variable" an own Mapping Table and Applymap in your facts table.

But you can load the "Variables" with their text also by joining them:

Factstable:

Load Field1,

Variable1,

...

From ...;

Left Join (Factstable)

Load Variable1,

Text1

From VarTable1;

...

Greetings from Munich