topic Re: mapping /applymap in QlikView

mapping /applymap

karolina_ — Tue, 18 Feb 2014 12:43:49 GMT

Hi All,

I have a problem with mappig/applymap. Hope somebody can help me.

MapNames:

Mapping

Load Distinct

[Table1.ID],[Table1.ID Name]

resident [Table1];

I have tried to achieve it in two ways:
#1

[Temp Table2]:

NoConcatenate

Load Distinct

Key AS Key1,

[Table2.CHILD ID] AS [Table2.CHILD ID1],

[Table2.CHILD ID] AS [Table2.CHILD Name1],

Resident [Table2]

Group by Key;

map [Table2.CHILD Name1] using MapNames;

[Temp Table2]:

NoConcatenate

Load Distinct

Key AS Key1,

[Table2.CHILD ID] AS [Table2.CHILD ID1],

ApplyMap('MapNames',[Table2.CHILD ID],'[None]') AS [Table2.CHILD Name1],

Resident [Table2]

Group by Key;

Tue, 18 Feb 2014 12:49:43 GMT

Please explain what are you trying to do or upload a sample document with some data and the expected output

Thanks,

Byron Van Wyk

Tue, 18 Feb 2014 12:59:32 GMT

Try without the GROUP BY

It seems correct

Fabrice

hic — Tue, 18 Feb 2014 13:08:10 GMT

In #1 you need to have the "map [Table2.CHILD Name1] using MapNames;" before you load the field.

In #2 you need to include [Table2.CHILD ID] in the Group By.

HIC

karolina_ — Tue, 18 Feb 2014 13:28:08 GMT

#2 is working perfect! thanks!

I'll retry #1 and update this post if succeed, at first I got script error

edit: both advices working perfrect. thanks again!