topic Re: calculate distance between 2 zip codes in Data Quality https://community.qlik.com/t5/Data-Quality/calculate-distance-between-2-zip-codes/m-p/2276284#M3154 <P>Talend haven't this function&nbsp;</P><P>&nbsp;</P><P>You can use or API (like Google) or databases with GEO information and database functions for calc distance from latitude/longitude</P><P>&nbsp;</P><P>You can search for some commercial source of information or collect them from everywhere, like:</P><P><A href="https://github.com/Gibbs/uk-postcodes" target="_self" rel="nofollow noopener noreferrer">https://github.com/Gibbs/uk-postcodes</A></P><P><A href="https://www.maxmind.com/en/free-world-cities-database" target="_self" rel="nofollow noopener noreferrer">https://www.maxmind.com/en/free-world-cities-database</A></P><P>&nbsp;</P><P>store in PostgreSQL or MySQL and design Your Job</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 20 Jun 2017 13:09:12 GMT vapukov 2017-06-20T13:09:12Z calculate distance between 2 zip codes https://community.qlik.com/t5/Data-Quality/calculate-distance-between-2-zip-codes/m-p/2276283#M3153 <P>I have a requirement to calculate distance between 2 zip codes. Is it possible to calculate using any of Talend Component ? Also I would not like to use Google API to get the required distance.</P><P>&nbsp;</P><P>Thanks in Advance for help.</P> Sat, 16 Nov 2024 09:36:39 GMT https://community.qlik.com/t5/Data-Quality/calculate-distance-between-2-zip-codes/m-p/2276283#M3153 Anonymous 2024-11-16T09:36:39Z Re: calculate distance between 2 zip codes https://community.qlik.com/t5/Data-Quality/calculate-distance-between-2-zip-codes/m-p/2276284#M3154 <P>Talend haven't this function&nbsp;</P><P>&nbsp;</P><P>You can use or API (like Google) or databases with GEO information and database functions for calc distance from latitude/longitude</P><P>&nbsp;</P><P>You can search for some commercial source of information or collect them from everywhere, like:</P><P><A href="https://github.com/Gibbs/uk-postcodes" target="_self" rel="nofollow noopener noreferrer">https://github.com/Gibbs/uk-postcodes</A></P><P><A href="https://www.maxmind.com/en/free-world-cities-database" target="_self" rel="nofollow noopener noreferrer">https://www.maxmind.com/en/free-world-cities-database</A></P><P>&nbsp;</P><P>store in PostgreSQL or MySQL and design Your Job</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 20 Jun 2017 13:09:12 GMT https://community.qlik.com/t5/Data-Quality/calculate-distance-between-2-zip-codes/m-p/2276284#M3154 vapukov 2017-06-20T13:09:12Z