Discussion Board for collaboration related to QlikView App Development.
I need your help.
I have field WOST tha can has four possible values : 'R' or "D" or "C" or "L".
R = Release
L = Close
How can translate into the script this instruction :
if WOSTS = 'R' then MYFILD = 'Release' or WOST= 'D' then MYFILD = 'Complete' or WOST= 'C' then MYFILD = 'Delete' or .....
Use a mapping table:
CodeNameMap:MAPPING LOAD * INLINE [ CODE, DESCRIPTIONR, ReleaseD, CompleteD, DeleteL, Close]; // or whatever the source is Table:LOAD *, ApplyMap('CodeNameMap', WOST) AS MYFILDFROM Table;
Hope that helps
GREAT t!!!Many thanks