i have a data set in mysql with fields
CUSTOMER_KEY, TRUVUE_ID, CUSTOMER_NM, HOME_PHONE, BUSINESS_PHONE, EMAIL, SOCIAL_SECURITY_NBR, ADDRESS, HOUSE_NBR, PIN_NUMBER, LNG, LAT, STREETNAME_SOUNDEX
below is my definition of the fields
fields = [{'field': 'CUSTOMER_NM', 'type': 'Name'},
{'field': 'ADDRESS', 'type': 'Address'},
{'field': 'SOCIAL_SECURITY_NBR', 'type': 'Exact'},
{'field': 'TRUVUE_ID', 'type': 'Exact'},
{'field': 'HOME_PHONE', 'type': 'Exact'},
{'field': 'BUSINESS_PHONE', 'type': 'Exact'},
{'field': 'EMAIL', 'type': 'Text'},
{'field': 'HOUSE_NBR', 'type': 'Exact'},
{'field': 'PIN_NUMBER', 'type': 'Exact'},
{'field': 'STREETNAME_SOUNDEX', 'type': 'Text'},
{'field': 'LatLong', 'type': 'LatLong'}
]
the code is failing with the below error
ValueError: Records do not line up with data model. The field 'LatLong' is in data_model but not in a record
in the patent example i see it is defined as type LatLong and in the csv it is present as LAT & LNG variables. so i defined my table columns as LAT, LNG and defined field type as LatLong. can some of help me here or direct me to a sample example where it is defined to use it?
i have a data set in mysql with fields CUSTOMER_KEY, TRUVUE_ID, CUSTOMER_NM, HOME_PHONE, BUSINESS_PHONE, EMAIL, SOCIAL_SECURITY_NBR, ADDRESS, HOUSE_NBR, PIN_NUMBER, LNG, LAT, STREETNAME_SOUNDEX below is my definition of the fields fields = [{'field': 'CUSTOMER_NM', 'type': 'Name'}, {'field': 'ADDRESS', 'type': 'Address'}, {'field': 'SOCIAL_SECURITY_NBR', 'type': 'Exact'}, {'field': 'TRUVUE_ID', 'type': 'Exact'}, {'field': 'HOME_PHONE', 'type': 'Exact'}, {'field': 'BUSINESS_PHONE', 'type': 'Exact'}, {'field': 'EMAIL', 'type': 'Text'}, {'field': 'HOUSE_NBR', 'type': 'Exact'}, {'field': 'PIN_NUMBER', 'type': 'Exact'}, {'field': 'STREETNAME_SOUNDEX', 'type': 'Text'}, {'field': 'LatLong', 'type': 'LatLong'} ]
the code is failing with the below error ValueError: Records do not line up with data model. The field 'LatLong' is in data_model but not in a record
in the patent example i see it is defined as type LatLong and in the csv it is present as LAT & LNG variables. so i defined my table columns as LAT, LNG and defined field type as LatLong. can some of help me here or direct me to a sample example where it is defined to use it?