on 03-18-2016 08:43 AM - edited on 07-27-2021 11:43 PM by APIUserOpsDM
This article features a workflow that will allow you to search for keywords within a column of text strings. Potential applications for this might be to scan a Twitter feed, customer product feedback or Facebook comments for keywords such as the mention of particular people, descriptive words or subject matters. For this example, the purpose will be to search famous science quotes for a select group of keywords.
In the first section of the workflow, we are performing the following functions:
In the next section of the workflow, we will:
In the final section of the workflow, we will complete the steps of:
Things to consider:
As with almost anything Alteryx, there is more than one way to do things. Try some variations and post anything you think is worthwhile!
Great workflow, thanks!
Great article! Could you also tell us how to do word search within multiple columns? This one searches words within one column. Other thing in my mind - how to get an output where all records (one row multiple columns) will be displayed if the word is found in at least one column within one row? Thanks.
Can't attach the sample workflow I built, but here's the workflow screenshot.
The conceptual logic behind many multi-column processes is to Transform them into a single column, do the process, and then join back up to the original data.
Hope this make sense.
Rod
Great template for this process! This helped me solve a long-standing question for an associate, and made me a hero! DanC is MY hero!
Great article, thanks!
I have a quick question about the join tool. I re-run the workflow by removing the join and sort tools and got the same result for the output. Could you please also explain a bit more why we need to join the original input file?
Thank you,
Hello,
This is really cool, did you created a macro with this?
If so would you share it?
Thanks
Diego
The current workflow in helpful in searching one word. If in Keyword for search input tool, I want to two words like "science technology". How to do that? Suggestions will be highly helpful.
@DanC This is very useful. What do you do if your key words are key phrases, such as "machine learning" or country names, such as "United Kingdom", or "United Arab Emirates"?