If you have an array of items, you can use an AppConnect formula using .uniq to extract unique values from the array and consolidate your data by removing the duplicate values.
For example, if your values were apple, apple, apple, pear, banana, the .uniq formula would return apple, pear, banana.
In this Article
Remove duplicate records while composing a CSV.
- Using the Workato List app, create a Size list equal to number of unique items in the array.
- Using the Repeat action, iterate through the list in the previous step. In this example, we are iterating 3 times.
- Select Append item to list in the Action dropdown. Create a new list, adding each unique item in each iteration. This will create a new list data pill that can be mapped to the source list field when composing the csv.
- Map the source list field with the list data pill created in the previous step.