Find Closest Geographic Location - Two Sets of Data

[JZabor]

Hello Qlik Community,

@Patric_Nordstrom 

I am currently working through a new build and the goal is to compare two locations (data sets) based on Zip Code, but the crux is that I may have a Zip Code in Column A, but not in Column B. Please note that I also do have coordinates available for both points (column A latitude/longitude, column B latitude/longitude)

I want to be able to provide the nearest zip code to Column A from Column B 

Column A
01001
01005
01105

Column B
01002
01005
01105

Outcome:
01001 -> 01002
01005 -> 01005
01105 -> 01105

Thank you

[Patric_Nordstrom]

The challenge is that the SSE can only work with one inline table as input. A workaround is make a csv temp table.

Pls see the GeoOperations CSV example.qvf  at:

https://community.qlik.com/t5/Qlik-Sense-Documents/GeoOperations-Examples-Qlik-GeoAnalytics/ta-p/175...

Thanks,

Patric

[OlivierS]

Hello patrick,

would you be so kind to show a script solution if we outerjoin the two tables and use a single dataset?