We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!

Alteryx Designer Discussions

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

Append numeric value to repeated names in a column

manreddy
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
3 REPLIES 3
atrozz
8 - Asteroid

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

Good Luck!!!

manreddy
6 - Meteoroid

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

atrozz
8 - Asteroid

You welcome and good luck!!!

Labels