Jun 21, 2023 08:57 AM
Hi all, I'm stuck as to what to do here. Hoping someone can help. I THINK a formula should be able to do this? Essentially I want to create a view that shows me only the records that have a zip code that matches a zip code of another record. I was playing around with the DeDupe app, but that merges records, which isn't what I want. I want to keep the records, but I want a view that lets me easily view where the duplicates are. Screenshot attached to help communicate what I mean. Thanks!
Solved! Go to Solution.
Jun 22, 2023 04:21 AM
Try:
1. Create a new table called "Zip codes"
2. Create a linked field to "Zip codes" from your current table
3. Copy all the values form the "Zip" column and paste it into the linked field
4. In the "Zip Codes" table, create a "Count" field, thus giving you the number of records that have that zip code
5. In your original table created a lookup field to display the "Count" field you just created
6. Create a view that only displays records that have a lookup field value >1
This should do what you're looking for I think
Jun 21, 2023 05:36 PM
Jun 22, 2023 04:21 AM
Try:
1. Create a new table called "Zip codes"
2. Create a linked field to "Zip codes" from your current table
3. Copy all the values form the "Zip" column and paste it into the linked field
4. In the "Zip Codes" table, create a "Count" field, thus giving you the number of records that have that zip code
5. In your original table created a lookup field to display the "Count" field you just created
6. Create a view that only displays records that have a lookup field value >1
This should do what you're looking for I think
Jun 22, 2023 09:24 AM
Yes! I never would have thought to do it this way, but I think it should work—thank you!!
Jun 22, 2023 09:25 AM
No, I mentioned above I had already looked into that extension, but I don't want to merge the records, only identify them.