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
¡Resuelto! Ir a solución.
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!