topic Re: Applymap() duplication in App Development

Applymap() duplication

chimiralavenkatesulu — Wed, 19 Nov 2025 10:20:59 GMT

Hi Every one,

is applymap() allowing duplicates? why? what is the final result? can any one answer me please

Re: Applymap() duplication

Daniel_Castella — Wed, 19 Nov 2025 10:40:53 GMT

Could you, please, provide more information about your issue or an example? You can load the mapping using distinct function to not allow duplicates. However, I think that, when doing the applymap it will depend on the table you are doing it. I mean, if that table has duplicates, the applymap will be duplicated too.

Kind Regards

Daniel

Re: Applymap() duplication

Lech_Miszkiewicz — Wed, 19 Nov 2025 10:47:15 GMT

applymap does not create duplicates however it allows map table to contain duplicates. It picks first value from the mapping table which matches the map.

so assuming you have mapping tables like below

map_from, map_to

a, 1

a, 2

the result of mapping value a will be 1 as that is the first value in mapping table.

You may also think about applymap as of vlookup equivalent.

cheers

Re: Applymap() duplication

Nagaraju_KCS — Thu, 20 Nov 2025 13:35:08 GMT

Mapping load is Row-by-Row Execution , when the main table is loaded, Qlik checks the mapping table for every single row. If the key field in your main table is 'A',

ApplyMap() finds the corresponding value in the map table and returns it.

If mapping table duplicate values for ID, data returns only for first value.

example:
ID, to_map
100, A
100, B

the result of mapping value will be A. (if it is first record B the result of mapping value will B)