mapping /applymap

[karolina_]

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;   

[#2]

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

[#3]

Try without the GROUP BY

It seems correct

Fabrice

[hic · Accepted solution]

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_]

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