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

[OTrieger]

@nanztm 

You should be able to do that with macros as Alteryx will need to take each time one keyword check it and then iterate the same with the next keyword.

[GrowthNatives · Accepted solution]

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! 🚀

[nanztm]

Thank you, followed it step by step and got what I needed (was confused at first because of the append field tool multiplied my data 😅)