If else or

[#1]

I need your help.

I have field WOST tha can has four possible values : 'R' or "D" or "C" or "L".

R = Release

D= Complete

C= Delete

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 .....

thank you

[Miguel_Angel_Baeyens]

Hello,

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

[#3]

GREAT t!!!
Many thanks

Regards