change a variable to binary

domax37

Hi , I'm new using Alteryx. 

I have this data base that contains wine with features. I would like to change the feature "quality " . In this column "quality" , we have number from 1 to 10 . I would like to add a column with 0 to 5= non profitable 6-10 = profitable . ( remove or add a new column with those 2 fields ) 

Can I do that in Alteryx ? 

My workflow is attached. 

thank you very much . 

C

Case2v1.yxmd

Pingu

You could use the formula tool.

Click add column and type Profitability.

Use iif([quality] <= 5,"non profitable","profitable")  as formula.

Make sure the input field quality is an integer (you can change using a select tool)