Renaming values within column

Hi All, fairly new to alteryx so apologies if this is a slightly rookie question.

To set the scene I have a dataset with ~250k rows. One of the columns called 'description' has around 200 unique values which are repeated many times. I want to individually rename these 200 unique values under 3/4 categories.

For example within the description there are entries such as 'tuna', 'mackerel' and 'mussels' which I would want to simply rename 'seafood'.

What is the best way to do this on Alteryx? If I was on Excel, I would create a table of the unique values and use a vlookup formula.

Any advice would be appreciated.

Thanks

Datasets

Preparation

Accepted answers

OllieClarke

@frae sorry, I can't have been clear enough. If you use a summarise tool to group by your commodity description, then that will give you a unique list of them. you can then use a browse tool to copy these values (and headers) from the results window (here:)

if you then right click the canvas, and click 'paste' Alteryx will create a text input with those 200 commodity descriptions, and you can easily assign them each a replacement value to feed your find and replace tool. Does that make sense?

lookup.yxmd

All comments

OllieClarke

Hi @frae the find and replace tool is very similar to a vLookup in Excel. Plug in your lookup table to the bottom anchor to replace values in the top anchor

Hope that helps,

Ollie

lookup.yxmd

Ladarthure

Hi @frae,

to do so, you can also do a table and then do a join with the newly created field, or use a formula like the one below:

if [description] in ('mussels, 'tuna'..) then 'seafood'

elseif [description in (...) then 'b'

else [description] endif

hope it helped!

frae

Hi Ollie, thanks for this. Is there a way to create this vlookup table in Alteryx rather than import from excel? Essentially adding a column and manually entering your 'replace' column which you created.

Fearghas

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703