Merging Rows for Unique IDs
Hi, I have a table showing customers, their current statuses, and when those statuses take effect.
As customers can have more than one status, we have duplicate customer IDs. I need to merge the statuses into one row, separated by a forward slash, so that each customer ID is unique.
Can this be done in a workflow?
0
Answers
-
Hello, yes can be done
Group step - to deduplicate same values into a single row, then Aggregate the Status column into a comma separated list (then Transform step to replace the commas with forward slash)
Another option is Harmonize step, since you know the IDs are duplicate customers you use a rule to only keep the customer record with the latest status.
0
