Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Updating a Value in a Column

SR
8 - 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

3 REPLIES 3
Kenda
16 - Nebula
16 - Nebula

Hey @SR! 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?

jrgo
14 - Magnetar

Hi @SR,

 

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

 

Regards,

 

Jimmy

SR
8 - Asteroid

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

Labels