Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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
Please explain what are you trying to do or upload a sample document with some data and the expected output
Thanks,
Byron Van Wyk
Try without the GROUP BY
It seems correct
Fabrice
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
#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!