Discussion board where members can get started with QlikView.
Hi All ,
Can someone please explain me what is this below applymap does ?
Thanks in Advance
Loads all rows with a Lead_UID value that doesn't appear in mapping table 'Disposition_Email', or that does appear in the mapping table but with a translation value of 'No'.
See here: ApplyMap ‒ QlikView
Loads all rows with Lead_UID value that appears in second column of mapping table with the condition "NO'.
ApplyMap('map_name', expression [ , default_mapping ] )
Return data type: dual
If stated, this value will be used as a default value if the mapping table does not contain a matching value for expression. If not stated, the value of expression will be returned as is.
Hope it helps!!
In addition to Peter's link, have a look at Steve's blog which illustrates how you can get the most out of Applymap
it will return the results with no mapping in the mapping table, as default mapping defined is 'no' and in where condition it is checking load only records with name as 'no'.