Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Append numeric value to repeated names in a column

Highlighted
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.

Alteryx Partner

You welcome and good luck!!!

Labels