This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have below script work fine , except for the red color expression not working :-
MAP_NAME_A:mapping LOAD RAW,NAMEFROM[MAP_A.xlsx](ooxml, embedded labels, table is MAP_A);
MAP_NAME_B:mapping LOAD RAW,NAMEFROM[MAP_B.xlsx](ooxml, embedded labels, table is MAP_B);
For Each i in 'A','B'
LOADCOY,SALESMAN,'$(i)' as SOURCE,ApplyMap('MAP_NAME_A',[SALESMAN],'OTHERS') as [SALESMANE_A],ApplyMap('MAP_NAME_B',[SALESMAN],'OTHERS') as [SALESMANE_B],ApplyMap('MAP_NAME_'$(i)'',[SALESMAN],'OTHERS') as [SALESMANE],SALESFROMCOY_$(i).xlsx (ooxml, embedded labels, table is COY_$(i));NEXT i;
Hope some one can advise me how to do it ?
I get below error msg :-
Error in expression:')' expectedLOAD
The final result :-
ApplyMap('MAP_NAME_$(i)',[SALESMAN],'OTHERS') as [SALESMANE],
Remove single quote around $(i). Within a String, if you use $, the variable will be automatically replaced with the value.
View solution in original post