Splitting a column into 2 on its value

[rajputakansha]

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

[T_Willins · Accepted 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.

[DiganP · Accepted solution]

@rajputakansha Attached is the workflow that dynamically finds the last month and separates it from the rest.