I've created an index as a geometry look up table, containing the geojson for UK postcode districts (~3000 entires)
I now want to overlay data from a raw data file (various text and values for each district but no geometry, ~1million entries), by joining to the geometry index using the text of the district name in both indexes.
I can get something on screen with a terms aggregation join i.e using the geometry index as the layer (left source) then and binding the raw data (right source) in the terms aggregation.
However, none of the right source data is visible on the map in the tooltips nor is any of the raw data filterable. (I was hoping to use the Controls widget to make it filterable).
Is what I'm trying to do possible with Maps, and if not, is there a clever workaround?
Thanks in advance!