Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Number rows based on text column

khanp27
6 - Meteoroid

I have a text column which I want to number and increment based on a condition. For example : where ever word "Finished' appears in text column just increment the number. 

 

Sample dataset

 

Text column
started running uefhrgfge
absdbd
jadhuesahd
ejuh3w
eurwe
finished feuihref
Started running swhdwe
dfiogehr
rgj
rejgir
rgmjoeg
finished swhdwe 

 

Desired output 

 

 

3 REPLIES 3
rzdodson
12 - Quasar

@khanp27 here is one (lazy) solution for you :)

 

Solution 1.png

caltang
17 - Castor
17 - Castor

Added some finesse to it!

 

image.png

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
flying008
15 - Aurora

Hi, @khanp27 

 

FYI.

 

录制_2023_09_07_11_55_40_146.gif

Labels
Top Solution Authors