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
Solved! Go to Solution.
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
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)