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're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!
Hello, I was hoping someone may be able to help me.
I am trying to create a new column using existing data from a current column, but the new data within the new column needs to be in specific code. EG:
I would like the workflow to read for example - IF COLUMN A READS/INCLUDES "REPAIR" OR "CAL" OR "SERVICE" THEN NEW COLUM SHOULD READ "REP", "CAL", "PM".
The new column would ideally read:
Please could someone advise how I would go about doing this?
Thank you in advance :).
Go to Solution.
Go to Solution.
Here's two approaches:
Depending on your data the 2nd option may be more scalable/require less maintenance if new keywords are ever added.
First you'll need a dataset of all the possible translations you want to perform like:
Then use an Append Fields tool to attach this list to all your incoming rows. Next add a Filter tool with an Expression like:
Contains([COLUMN A], [Keyword])
The T anchor of the Filter will have your translated rows.
@Luke_C This is great thank you so much! I think the table option is best in case any other variables come in!
@MattBSlalom This is exactly what i need, thank you so much, I have never used the Append Fields tool before so this is great to try out.