Alteryx Text Modelling
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Alteryx Community,
I would like to ask whether is there a feature in Alteryx where I can input string such as 'Reviewed, approved, good to go, no further comment' in a dictionary within Alteryx (like a training model), and subsequently Alteryx would help identify column that contains these string / approximate strings.
Thanks and regards.
- Labels:
- Fuzzy Match
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @James89 this can be used by just simply using a formula tool where you can write such as if [column] ="approved" then 1. in this way you can use the flagging. The other way can be using find and replace tool if you want to replace these with something else
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Manoj,
Thank you so much for the assist. My question would be let's say my Alteryx String contains for example: "I have eaten an apple." under column titled 'Value'.
What would be the formula or rather tool to get Alteryx to flag if Alteryx detects 'eaten'/ 'eat', it would flag 1 or YES.
Thank you so much for the assist once again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @James89 i have attached the solution, you can get the output in two different ways by filter and by formula field
 
![](/skins/images/1AD6617C767659D8A9F9801BEDFCFB20/responsive_peak/images/icon_anonymous_message.png)