Create a new column based on the row and column values

[senthil_kumar_1]

I am new to Alteryx. My workflow is accepting a below Text Input. I would like to create a new column based on the column 'Severity' and populate the value in the new column. 

Appreciate any help pls. 

Input Data

Input Data

Output Data 

Output Data

[aatalai · Accepted solution]

@senthil_kumar_1 see if this helps , let me know how you get on

[senthil_kumar_1]

Thanks a lot. It worked 👍