Row_Number() over Partition by concept not returning right values

[Shyamal_666]

Hello All,

I am trying to implement the Row_Number() over Partition by concept in Alteryx, but whenever there's a group of same items more than 2 times, from 3rd time the multi row formula is returning the previous row value. Just not sure why. I am a newbie to Alteryx, so not sure about all the tricks. I am attaching the Workflow and desired output, if anyone can, please do help!

[JosephSerpis · Accepted solution]

Hi @Shyamal_666 I mocked up a workflow that produces the output you describe.

[Shyamal_666 · Accepted solution]

Hello Joseph,

That just worked as expected!! Thanks so much for your quick help!

Shyamal