I have 3 columns product,date,sales
There are 3 products.
Each product has 5 years of data month wise
i want to create a new column and if any products last year(12 months) sales value is 0 I should update the value in the column as discontinued for that product..
How can this be acheieved in Alteryx
Solved! Go to Solution.
Hi Emil,
Hi @Sharathkrishnan,
What I am doing here is identifying the max year for each of the product. If max year sales are 0 I am populating status off.
Hi Emil,
Can you please tell me what was wrong in the previous version ? I am not able to figure it out..
Hi @Sharathkrishnan,
I will reply to your direct message propably tomorrow.
Regarding the workflow, I forgot to include only the data that have 0 as a sales value for the year. Previously it set the status for off for each position in the newest year.