I have two associated datasets for households and bank branches. I have created travel areas around each bank branch and a point map of the households using Lat, Lon. I need the travel area (polygon) selectable to select the households (points) within that travel area.
When I load a small sample (10) of the housholds the data loads, creates 3 synthetic keys, a circular reference and the engine fails.
When I load a larger sample (100) of the households the load fails with a null error (though no nulls exist).
i am finding very very little documentation on using within and the within example is using a point within a standard area rather than a loaded table polygon and I am unable to use it to make my app work.
Is there anyone out there that has successfully done this that would be able to help me out?
My data model and settings for the within are as follows.
Switch the order of the indata, the first dataset should be the points you want to test with and the second dataset is the areas (in your case TravelAreas.)
Check out the example for "Within"
I would plot the branches and the travelareas on a map first to get a visual check of which branches that falls into which area. Sorry for being unclear, I meant fill in the parameters like this:
I have tried both and I get the same result.
here is a setup with your suggestion and i get the same result. 0 records found in the withinassociations table.
Ok, that's odd, could you share the indata?
Please note the order for 'Latitude and Longitude Point', the last screenshot has the wrong order for the fields.
Should be HHkey,HHLat,HHLon.
I would also drop the 'B.' in front the travelarea table fields.