Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

count if

pangersandmash
6 - Meteoroid

Hello,

 

I am trying to replicate an excel count if formula. The difference with this is I want to count all items down a list, but nothing above. See below attachment for illustration

pangersandmash_0-1607608620188.png

pangersandmash_1-1607608650803.png

In this example, the count on 2135658HFA is 3 (in total). but by the second one, the count excludes the one above. so there are only 2 to count. Then on the last it becomes 1, as it excludes the 2 above.

Essentially, i want to allocate a "1" next to the LAST unique concat 2. 

Please help!!!

Thanks

kumaranvr1984
8 - Asteroid

Here is the workflow with your input data file.

 

Regards,

Kumaran

Labels