Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

karolina_
Contributor II

mapping /applymap

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;

#2

[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;   

Tags (2)
1 Solution

Accepted Solutions

Re: mapping /applymap

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

4 Replies
Not applicable

Re: mapping /applymap

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

Thanks,

Byron Van Wyk

QlikVieW & Other Ramblings

Not applicable

Re: mapping /applymap

Try without the GROUP BY

It seems correct

Fabrice

Re: mapping /applymap

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_
Contributor II

Re: mapping /applymap

#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!