Reverse Split Delimited Text

1

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 | LOB
Server 1 | ABC
Server 1 | XYZ

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

2

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

1 Like