Applymap

[smilingjohn]

Hi All ,

Can someone please explain me what is this below applymap does ?

where ApplyMap('Disposition_Email',Lead_UID,'No')='No';

Thanks in Advance

[Peter_Cammaert]

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

[lalitkgehlot89]

Loads all rows with Lead_UID value that appears in second column of mapping table with the condition "NO'.

[Anonymous]

Hi

ApplyMap('map_name', expression [ , default_mapping ] )

Return data type: dual

Arguments:

Argument	Description
map_name	The name of a mapping table that has previously been created through the mapping load or the mapping select statement. Its name must be enclosed by single, straight quotation marks.
expression	The expression, the result of which should be mapped.
default_mapping	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!!

[ngulliver]

In addition to Peter's link, have a look at Steve's blog which illustrates how you can get the most out of Applymap

https://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Cheers,

Neil

[Anonymous]

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'.