Reverse Split Delimited Text

I’m looking for something like the opposite of “split delimited text” action. Consider if I have multiple rows that might be considered duplicates across a subset of columns. I’d like to combine them into one row but with the data in the other columns concatenated together with a delimiter.

If before the action the data looks like this…
Server 1 | ABC
Server 1 | XYZ

After the action, I want the data to look like this…
Server 1 | ABC,XYZ

The “Aggregate” action has the “Concatenate” mode which also allows specifying a delimiter.

1 Like