I have a customer table containing name, address, city, zip_code, phone and other fields. Table contains few thousand rows. But there few rows (<100) having one field empty say city. Need a technique to suggest a value for these empty fields from similar records like zip code, phone number etc. Looking for a generic rule. I am using java here.
1.4m articles
1.4m replys
5 comments
57.0k users