Hello everyone, is it possible to check if in an array of elements there is a duplicate, using only functions and not actions? I've got a column that contains an array of elements, example: A,B,C,F,B,D I need to check if an element is duplicated. I created a module (that split into rows > keep d…

Hi @AndreaM , If the column contains separated values, you could try using the following expression: (substringcount([Column], ",") + 1) > setlength([Column]). The setlength function returns the number of unique separated strings in a list/array. The default separator is a comma, but you can specify…

EasyMorph Community - Data preparation professionals and enthusiasts

Duplicated data in array elements

AndreaM July 15, 2025, 10:15am 3

Thanks for the help, really nice solution!
Perfect!

1 Like

To learn more about EasyMorph visit easymorph.com.