I have a data set where I am looking if keywords from a list exist in a cell and to also list out all the words that exist.
Attached is a screenshot of the workflow and output. I added an index filed to the data first. I then did an append so each record gets replicated for each unique keyword in the list. I then have a formula to check if the keyword is there and if yes, populate the cell with that word. I then group by my index and concatenate the keywords pipe delimited so I can see which keywords exist in the original raw data field.
How can I reduce Concat_Unique_Keyword_Flag field so that it only has the keywords found and get rid of all the blank cases?
Thanks!
David
Solved! Go to Solution.
the easiest way is probably to just filter isempty([unique keyword] right before sum... or maybe a formula with REGEX_Replace([Concat_Field1],"([!\|!\|])+","$1") after?
Of course... the filter! How stupid of me.
Although RegEx is always cooler 🙂
Thanks!