Hi Anandit,
If you have an array of items e.g. ["apple","apple","apple","pear","banana"], you can use formula .uniq to extract unique values from the array i.e ["apple","apple","apple","pear","banana"].uniq returns ["apple","pear","banana"]. This is a simple example that you may expand on.
To transform the array to a list data pill for use in a source list field, you can create a list using a combination of the following actions
1) Using Workato List app, create a list of size equal to no. of unique items in array
2) Using Repeat action, iterate through list in (1) i.e. iterate 3 times
3) Using Append item to list action nested in Repeat action, create a new list, adding each unique item in each iteration --> this creates a new list data pill you can map in the source list field when composing csv
Screenshots of Recipe input:
1) Using Workato List app, create a list of size equal to no. of unique items in array
2) Using Repeat action, iterate through list in (1) i.e. iterate 3 times
3) Using Workato List app, Append item to list action nested in Repeat action, add each unique item in each iteration --> this creates a new list data pill you can map in the source list field
4) Mapping source list field with the list data pill created in (3)
Send us a ticket, we will try our best to assist you with your problem
Anandit Joshi
Removing Dupes from CSV