In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Row_Number() over Partition by concept not returning right values

Shyamal_666
5 - Atom

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!

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

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

Shyamal_666
5 - Atom

Hello Joseph,

 

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

 

Shyamal

Labels
Top Solution Authors