Lia Nungaray
asked on
How to consolidate two similar rows
I have a table which has clients and addresses. The client ID may have two different addresses, for example Main Rd and Main Road. Is there a way to eliminate these rows? For example:
Client ID Address
1001 123 Main Rd
1001 123 Main Road
1002 586 Smithridge Dr. Suite C
1002 586 Smithridge Dr. Ste C
After query, only have two rows:
1001 123 Main Rd
1002 586 Smithridge Dr Suite C
I am using Snowflake, and I have used the EDITDISTANCE formula but for similar fields in the same row, not different rows.
Thank you
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.