quickest way to remove duplicate people contacts which are in 2 different tables?
Hey there Ravi thanks for reaching out, the best way to do this would be to use a look up row and other table integration. The way this will be set up is that in the table you will wish to delete these duplicate values You'll run the lookup integration from that table, When running the lookup choose a value you know will be inside of both tables and will have a match. Once you have run the integration and your results are generated you will get one of two outputs. The first being a record found with a green check box and the other being zero records found with a red X. What you do then is you will filter out for all the rows where there was a result which will give you all of the record found with green check mark rose then from there you can go ahead and just delete these as these are the duplicates that you do not want