To achieve the desired output in Alteryx, you can follow these steps:
Input Data: Load your input data into Alteryx. Use the "Input Data" tool to bring in your data.
Data Cleansing:
- Use the "Data Cleansing" tool to clean up any missing or inconsistent data.
- Convert 'None adjusted' to 0 in the 'amount adjusted in past 6 months' and 'amount adjusted in prior month' columns.
Formula Tool:
- Add a "Formula" tool to create a new column called 'Summary' using the following expression:
If [amount adjusted in past 6 months] = 0 Then "This teammate has not had any orders at risk in the past 6 months" Else "This teammate has adjusted $" + ToText([amount adjusted in past 6 months]) + " in the past 6 months, $" + ToText([amount adjusted in prior month]) + " which was adjusted from the prior month."
Select Tool: Use the "Select" tool to reorder the columns as needed.
Output Data: Use the "Output Data" tool to save the results.