Alteryx: Categorized by multiple words with category "other"

Hi, I'm pretty new to Alteryx, so I Have a question..

I have survey results, and I'm trying to categorize replies by some words. You can see the list of words (some) with a key in the photo (mapping key).

mapping Keys.png

In the photo "functions", you can see all the functions that I created.

As you can see from the photo "results," it is categorized based on my keywords, and it's perfect.. but I would like to add the option "Other." So, if they replied to the question with something and they aren't categorized in the keys (in the mapping keys), please print "Other."

Find Replace.png

So how can I add the category "Other", if they write something that isn't categorized? I don't know if it is possible..

Thank you so much!

Best Practices

Accepted answers

shancmiralles

hi! use a join tool first to match the words you have with your data and keys.. then the words that would appear to have no match , use a formula tool to fill the cells with the word "others".. tho you might want to change the data type for the key column into v_w string.
hope this helps!
@Nesly

All comments

TUSHAR050392

Hey @Nesly I am a bit unclear about the ask. Do you want to create a new column Others or update the Null values in Keys columns to Other?

If you want to create a new column, then you can use a formula tool and create a new column - Other and mention the formula - IF ISNULL(Keys_Q77) AND ISNULL(Keys_Q63) AND ISNULL(Keys_Q45) THEN 'Other' ELSE Null() ENDIF

If you want to update existing Key columns then use a Multi field formula and select all the key columns and mention formula - IF ISNULL(CurrentField) THEN 'Other' ELSE CurrentField ENDIF

Let me know if this helps

shancmiralles

Nesly

Thank you so much! you anticipated my error with "change into v_w string." too ahah

OTrieger

@Nesly
You can add a Formula tool after each Find And Replace and with use IF null then Other ELSE Key you will end up with all the items that does not have key with Other.

OTrieger

Or with a multi field for formula after the multi join tool, if Null then Other else Current Field, marking all the Key fields

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703