This is for my schema here:
I'm getting the error:
Could not access blank value: Use || to provide a default value for blank fields. Example: (my_field || 0) + 1
For all fields. I'm trying to match based on field 'State' which exists with all data in both the schema and the dataset.
Ideally, I'd like to match based on distance, from user. For example if we can match all of city, zip, state, then that would be the best match, if not, then just zip and state, then last just state (even better would be by closely related zip codes, so 02818 and 02919 would be considered close to one another).
Lastly, this is for a simulated user database, so it would be nice to have some randomization, and not always go for the last match.
This is quite the laundry list I know. Really I just want to fix the error. If there is a way to accomplish any of the above that would also be appreciated.