IF AND STATEMENT

[Judicael]

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.

[Anil_Babu_Samineni · Accepted solution]

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

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