If- then formule

[francisvandergr]

Hello

Often i use this kind of formula: if (CategoryID= 5 or CategoryID=6,'Footwear','Clothing') as CategoryType

Now i have a problem with a field: status In this field i can have 3 values

O , M or F ; this values i wanna translate to

O=Off M=Mag and F=Fac and the field must have the name Status

if (Status=O, .................................. ?

Who can help

[Miguel_Angel_Baeyens · Accepted solution]

Hello Francis,

You may use something like (untested)

If(Pick(Match(Status, 'O', 'M', 'F'), 'Off', 'Mag', 'Fac'))

But I'd strongly recommend you to use a mapping table:

StatusMap:MAPPING LOAD * INLINE [Input, OutputO, OffM, MagF, Fac]; LOAD *, ApplyMap('StatusMap', Status) AS StatusFROM file.qvd (qvd);

Hope that helps

[#3]

You can use something more simple.....

IF(Status='0','Off',IF(Status='M','Mag','FAC'))

[francisvandergr]

thank you. I have made a mapping table. I can use this often in future!