Hi all,
I have a data set with column- Month, ID and Value.
I want Alteryx to create a separate column "Value2", dynamically for the last month and column "Value1" for all other months.
Example:
Month | ID | Value | Value 1 | Value 2 |
1 | AA | 10 | 10 | |
1 | AB | 15 | 15 | |
2 | AA | 10 | 10 | |
2 | AB | 20 | 20 | |
2 | AC | 5 | 5 | |
3 | AA | 10 | 10 | |
3 | AB | 30 | 30 | |
4 | AA | 25 | 25 | |
4 | AB | 15 | 15 | |
4 | AC | 0 | 0 |
Can you suggest a way to achieve this?
Appreciate your help!
Thank you
Solved! Go to Solution.
Hi @rajputakansha,
Here is an easy way to accomplish this. This will work if your month in is a numeric or date format. If it is a string format, then some additional data prep will be required.
@rajputakansha Attached is the workflow that dynamically finds the last month and separates it from the rest.