Put Numbering with condition

[SH_94]

Hi Community,

May i know how to write the formula in the multi-row formula tool  so that output is as per below:

The condition is that for the first month it will start with A whereby record ID is 1 for A , 2 for B , 3 for C and 4 for D. While for the second month onwards, it will opposite and start with D instead and so on.

Output

Many thanks

[ShankerV]

Hi @SH_94 .

Try this, I have just added the Select tool to make sure the Month field is Int32 and Type is String.

[ShankerV]

 @SH_94 

The above solution will work, as Month field in your Alteryx might be considered as String.

Its version issue where I am using the higher version.

Please let me know if the solution works in your system.

Many thanks

Shanker V

[SH_94]

Hi @ShankerV ,

I still have the same output , is there anyway to build the formula so that it able to derive the result wanted?

Thanks

[ShankerV]

Hi @SH_94 

Sure, you can build the same formula.

Step 1: Input the data

Step 2: Use the summarize tool to get the Max

Step 3: Join tool

Step 4: sort connected to J node

Step 5: sort connected to R node

Stet 6: Union tool

Finally, multirow tool

Result:

Many thanks

Shanker V

[ShankerV]

Hi @SH_94 

By last chance, try this workflow attached.

Had made few tweaks, which might work for you.

[ShankerV]

Hi @SH_94 

Did it worked? 

If yes, Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V