We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

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