removeduplicates - Remove Duplicates from an Array
Removes duplicates from an array. If the fields parameter is empty, all fields of the first array element are used for the comparison.
data
array
Array of lines with mixed values.
Minimum: 1
Example:
[
{
"Column1": "Germany",
"Column2": "Apple",
"Column3": "Dragonfruit"
},
{
"Column1": "Germany",
"Column2": "apple",
"Column3": "Dragonfruit"
},
{
"Column1": "US",
"Column2": "Apple",
"Column3": "Dragonfruit"
}
]
fields
array
Array of fields to compare for uniqueness. If the fields parameter is empty, all fields of the first array item will be used for the comparison.
Example:
[
"Column2"
]
ignoreCase
boolean
Sets case sensitivity for operation.