Any reason why you want to do it in the frontend, wouldn't it be easire to remove or mark the same in the backend i.e. data integration

How would I do it for data integration?

Hey @richanda.wrigh ,

you would navigate to data integration and then add a transformation and name it e.g. 'Test' - here in this area you have the possibilties to code this via SQL:

With PhoneNumberDuplicates AS (

SELECT *,

COUNT(*) OVER (PARTITION BY PhoneNumber) AS PhoneNumberCount

FROM Table (table where the phone number is stored))

SELECT * FROM PhoneNumberDuplicates

WHERE PhoneNumberCount >1;

thank you