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