PQL - I am trying to find duplicate phone numbers within my table. Does anyone know how I can write this PQL?
Best answer by julia.bauer
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;
+4Any 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
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?
+1How 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;
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.