community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Updating a Value in a Column

Asteroid

HI All,

 

I have a data set where i am trying to update particular values thats missing manager name as per those values in the same column that include a manager name.

 

Level 2Level 3
SALES (ROB)SALES 1 (BOB)
SALESSALES 1
FINANCE (John)ACCOUNTING (CARL)
FINANCEACCOUNTING

 

In the above table, i want to update the values "SALES" to "SALES (ROB)" or FINANCE to FINANCE (John)  . How do i do this.  I tried splitting the columns but i am unable to get the manager name associated to the rows where the entry is missing.

 

Thanks

SR

Pulsar
Pulsar

Hey @sr49ers! Try using the attached workflow. The key was to use a Filter then a Formula and the Find and Replace tool. You could also replicate this if you wanted to perform the same actions to the Level 3 field. Does this work for your purposes?

Highlighted
Alteryx Certified Partner

Hi @sr49ers,

 

See if the attached example provides you with what you're looking for.

 

Regards,

 

Jimmy

Asteroid

this is perfect. Thank you so much. you been so helpful!!!

Labels