How can I groupby concatenating string and remove where there is no string?

[David_Mosk]

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

[apathetichell · Accepted 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?

[David_Mosk]

Of course... the filter! How stupid of me.

Although RegEx is always cooler 🙂

Thanks!