Keyword search and count

nanztm

Hello, I am new to alteryx and was wondering if the below scenario can be achieved:

I have a data set that will contain a remarks field [main Data sheet on the attachment] and a list of Keywords [Keywords sheet on the attachment]

I need to search the keywords from the Keywords sheet if mentioned on the main data remarks and then returns how many keywords were found and the corresponding keywords found (concatenate if multiple)

Notes: I cannot use comma as delimiter as it may or may not contain it

Thank you

sample data.xlsx

GrowthNatives

Hi @nanztm 

Yes, this can be achieved in Alteryx. Here's a simple approach:

1. Use two Input Data tools — one for Main Data (Remarks) and one for Keywords.

2. Use Append Fields to combine each remark with each keyword.

3. Add a Formula tool:  IF Contains([Remarks], [Keyword]) THEN 1 ELSE 0 ENDIF

4. Use Filter to keep only matches.

5. Use Summarize to:

   • Group by your Remark or ID

   • Count keywords found

   • Concatenate matched keywords (use |, /, or another delimiter instead of a comma).

6. Join back with the Main Data if needed.

">⭐Hope this solution helps you make the most of Alteryx! If it did, click 'Mark as Solution' to help others find the right answers.

💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!

🚀Let’s keep building smarter, data-driven solutions together! 🚀