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

@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-conditions/m-p/921065#M224998
?

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