Alteryx Designer Discussions

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

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

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.

Highlighted
Alteryx Partner

You welcome and good luck!!!

Labels