Discussion Board for collaboration related to QlikView App Development.
Below script work fine :-
MAP_NAME:mapping LOAD RAW,NAMEFROM[MAP_A.xlsx](ooxml, embedded labels, table is MAP_A);
For Each i in 'A','B'
'$(i)' as SOURCE,ApplyMap('MAP_NAME',[SALESMAN],'OTHERS') as [SALESMANE_],
COY_$(i).xlsx (ooxml, embedded labels, table is COY_$(i));
Above script generate below table :-
Noe the highlight red color line not able recode SOURCE = B
Hope some one can advise me.
Below is my Map Table for SOURCE A.
This looks like it's working correctly? There are no mapping values associated with the latter two values, so they are assigned OTHERS.
Above is the sample file i created , hope you can advise me.