We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

Find and Replace "override"

doypadilla
6 - Meteoroid

Hi community!

 

I have a static text input tile of job title keywords that are associated with a specific department and arranged by priority. When I upload an Excel file to label new titles, I use find and replace to properly place them in the right department. Example:

 

KeywordDepartment
supportContact Center
customerContact Center
systemsIT
product managerEngineering & Dev

 

It is to my understanding that Find and Replace looks at the words in the Excel file and labels them according to the keyword it sees first. But the thing is, I want it to be labeled based on the priority like above. So "Systems Administrator Network Support" should be in Contact Center instead of IT.

 

Is there a way to make Find and Replace behave this way or is there a different way I could go about this?

 

I'm open to any suggestions.

 

Thank you so much! 😄

2 REPLIES 2
RolandSchubert
16 - Nebula
16 - Nebula

Hi @doypadilla ,

 

a solution could be to use the Append Fields tool to add all records (= all possible assignments). The first record containing the keyword should be the right department. I've attached a sample workflow. Let me know if it works for you.

 

Best,

 

Roland

doypadilla
6 - Meteoroid

Hi RolandSchubert.

 

Thanks for your help! I opted to use formula instead as I don't want to flag any keyword and remove them. But your workflow gave me ideas on a whole different topic.

 

Thanks again!

Labels