Remove Duplicates

Hi how are you, I have a base with ID, emails and Cell Number,
I would like to eliminate duplicate values, because I have an ID with several emails or with several cell Number, In some cases the email is the same but the cell number changes,
I want to delete an ID and choose only one with Email and Cellular number

Usually this is a job for the GroupBy node. Group on your ID and choose an appropriate aggregation function (e.g. unique concatenate, list). This way you get one row per ID with collection cells for email and cellular.

1 Like