We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Pulling Out Certain Words from String and Outputting to succeeding columns

muddobber26
8 - Asteroid

Hello - I have a description field that consists of anywhere from a 2 to 12 word description. The data set I have consists of about 12,000 different descriptions. I have created a "key words" (~45 words) list based on a cursory review of the descriptions. I am looking to right some type of macro or workflow in order to look at each "description" and pull out any of the "key words" and output them to additional columns. It is my way of distilling a bunch of freeform descriptions into certain common words. Because the list is long, I can't write a simple if/then statement. I have attached an example data set that has the "description", "key words" and "desired outputs". Can someone help me with this?

2 REPLIES 2
BrandonB
Alteryx
Alteryx

One approach - workflow attached:

 

BrandonB_1-1669653753951.png

 

 

 

 

 

Felipe_Ribeir0
15 - Aurora

Hi @muddobber26 

 

One way of doing this

 

Felipe_Ribeir0_0-1669654917566.png

 

 

Labels