What is the Difference between ApplyMap and Resident load?

[jonesbrown]

Hi All

I am new to Qlikview

What is the Difference between ApplyMap and Resident load?

plz help.

[swuehl]

RESIDENT is specifying a table source to load the data from (other possible sources, external tables loaded from DBMS or files using FROM or tables defined in the script using INLINE).

ApplyMap() is a function to map a field value to another value using a MAPPING table.

Hence these are two completely different things.

More info can be found searching the help or this forum:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/load-data-from...

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptRegularS...

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/MappingFunctio...

Mapping … and not the geographical kind

[jonesbrown]

Thank you sir

[MindaugasBacius]

Applymap() is a function that recall previously loaded Mapping table. It have three special properties:

1. It only have two columns. The first being the lookup value and the second being the mapping value to return.
2. It is a temporary table that is automatically dropped from the data model.
3. If no lookup value is found you can define the missing value.

Using Resident and Joining it:

1. Loads many fields.
2. If no match is found you cannot define a default value.
3. In case the Resident table have any duplicate values the Fact table will provide misleading results.

[jonesbrown]

Thank you  Sir.