IF or Wild Match

[Purushothaman]

Hi Experts,

I would like to change the field value of Raw Column as Seg in the below in backend  ;

Any Suggestion to use IF or Wild match ?

Please help

Thank you

[Or · Accepted solution]

If this is a full list of values, you could load it inline and use a mapping load, or you could use a pick/match statement such as:

Pick(Match(Raw,'1 DOOR >90 CM','1 DOOR 81 - 90 CM','SIDE BY SIDE'),'1 DOOR', '1 DOOR','SBS')

You could shorten this a little with Wildmatch by using e.g. '*DOOR *' for the top three, but honestly, with a list this short I don't think it's worth the bother, just type out the entire list in a regular match statement.