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