Link to home
Create AccountLog in
Avatar of Lia Nungaray
Lia NungarayFlag for United States of America

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
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer