Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
karolina_
Creator II
Creator 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;   

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

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

View solution in original post

4 Replies
Not applicable

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

Try without the GROUP BY

It seems correct

Fabrice

hic
Former Employee
Former Employee

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_
Creator II
Creator II
Author

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