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

[Sebastiaandb]

Hi @domax37 ,

Can you add the data to your example? (save via Options -> Export workflow). 

Besides that, can you elaborate a bit more on what you want to achieve? 

- You have a column named "Quality" and it has a range of 1-10. 

- You want to have another column based on quality that gives it a label of "non-profitable" if quality is 0-5 and "profitable" if quality is 6-10 (0 wouldnt matter in this case)?

Greetings,

Seb

[Pingu · Accepted solution]

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)