I’ve create a simple list of keywords in a table with a single column.
The aim of the project is to have a table where I can input as much text as I want into a row and see which keywords are contained in that text and the total number of keywords in that text.
I have another table that contains three columns - #1. Text // #2. Number of Keywords in Text // #3. Keywords in Text
I am unable to figure out how to write the formula to aggregate and count outputs #2 and #3.
Here is the working example.
Thanks in advance for any guidance,
Here’s one solution but there’s probably a “cleaner” one!
Great job @Nick_Milner , thanks giving me the chance to learn something new
@Nick_Milner thanks so much for figuring this out! I would have never been able to do this and I definitely learned something new here.
I am truly grateful and humbled by your help.
Thanks so much!
Keywords.Filter(thisRow.Text.Find(CurrentValue.Keyword)!=-1) formula on your Text table would work bit better performance wise
Told you there was a better way to do it.
Thanks for putting that together - your formula is incredibly simple.