topic Re: What is the Difference between ApplyMap and Resident load? in QlikView

What is the Difference between ApplyMap and Resident load?

jonesbrown — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I am new to Qlikview

What is the Difference between ApplyMap and Resident load?

plz help.

Re: What is the Difference between ApplyMap and Resident load?

swuehl — Sat, 13 Oct 2018 09:46:26 GMT

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-previously-loaded-t…

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

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

Mapping … and not the geographical kind

Re: What is the Difference between ApplyMap and Resident load?

jonesbrown — Sat, 13 Oct 2018 09:55:49 GMT

Thank you sir

Re: What is the Difference between ApplyMap and Resident load?

MindaugasBacius — Sat, 13 Oct 2018 21:46:00 GMT

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

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

Using Resident and Joining it:

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

Re: What is the Difference between ApplyMap and Resident load?

jonesbrown — Sun, 14 Oct 2018 04:39:06 GMT

Thank you Sir.