Using a formula to create a new column with multiple conditions

[Sifiso]

Hi there

I want to create a new column as follow:

please help.

[JarekSkudrzyk · Accepted solution]

@Sifiso 

have you tried similar approach to the one presented in this post:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Create-a-new-field-based-in-multiple-c...
?

I believe you should be able to do that by updating the mapping files from the workflow and amending formula.