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.
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:
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?
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.