ApplyMap

[NavinReddy]

Hi All,

I have Two tables one is FACT table haveing 120 million records,second is Dimention table having some records

i need to be use Dimentions Table Fields in Fact table

What is the best way Plz tell

Thanks in Advance

Niranjan

[hic · Accepted solution]

Load the dimension field as a mapping table and then use ApplyMap. See more on

http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap

HIC

[NavinReddy]

Hi Henric,

Could you plz tell me,what the about datamodel ,

How could i design in table viewer

Thanks

Niranjan

[hic]

You need to make the changes in the script, according to the following:

MapDimensionField:

Mapping Load DimensionID, DimensionValue From Dimension ;

Facts:

Load *,

   ApplyMap('MapDimensionField', DimensionID, null()) as DimensionValue

   From Facts ;

HIC

[vikasmahajan]

Henric Sir,

Can I use appy map function to calculate customer wise oustanding ?

Please reply

Thanks

Vikas

[NavinReddy]

Hi Henric,

Thanks  a lot  really its help full for me & other

Thanks

Niranjan