This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!
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:
Keyword | Department |
support | Contact Center |
customer | Contact Center |
systems | IT |
product manager | Engineering & 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! 😄
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
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!