IF AND STATEMENT

Judicael — Sat, 16 Nov 2024 03:43:52 GMT

Hello,

I have a field STATE with values : START , IN PROGRESS, ENDPOINT, COMPLETED, N/A

I want to transform the field STATE like START, IN PROGRESS, ENDPOINT, COMPLETED, N/A, MIXTE where MIXTE ={IN PROGRESS AND ENDPOINT}

ID, STATE_OLD, STATE_NEW

001, IN PROGRESS, MIXTE

001, ENDPOINT, MIXTE

Thanks for your help.

Regards.

Re: IF AND STATEMENT

Anil_Babu_Samineni — Fri, 26 Apr 2019 17:59:45 GMT

As far i understand the question, You may need this?

If(Match(STATE, 'IN PROGRESS', 'ENDPOINT'), 'MIXTE', STATE) as New_Field