Alteryx designer Discussions

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

Append numeric value to repeated names in a column

6 - Meteoroid

append numeric value to repeated names a column, I tried with multi-row formula but it is not working as expected,Please help me to resolve this issue

Input

NameEmail
abcabc@a.com
abcabc1@a.com
bcdbcd@a.com
defdef@a.com
ghighi@a.com
abcabc3@a.com
jkljkl@a.com
mnomno@a.com
pqrpqr@a.com
bcdbcd@a.com
abcabc@a.com
defdef@a.com

 

Output should be:

NameEmailvalue
abcabc@a.com1
abcabc1@a.com2
bcdbcd@a.com1
defdef@a.com1
ghighi@a.com1
abcabc3@a.com3
jkljkl@a.com1
mnomno@a.com1
pqrpqr@a.com1
bcdbcd@a.com2
abcabc@a.com4
defdef@a.com2
Highlighted
Alteryx Partner

Hello. Look my workflow. You need a running total tool.

Good Luck!!!

Highlighted
6 - Meteoroid

It is working as expected..thanks for your quick response.

Highlighted
Alteryx Partner

You welcome and good luck!!!

Labels