https://community.qlik.com/t5/Data-Quality/How-to-load-valid-data-catalogs-for-data-profiling-and-data/m-p/2262262#M1741 <P>Hi everybody,</P> <P>I have CSVs and relational tables with names, adresses, postal codes, phones, etc.</P> <P>In the case of data profiling with TOS Data Quality AND Data Preparation:</P> <P>How could I aggregate local valid postal codes and street names to Talend?</P> <P>The postal codes in TOS Data Quality are from different countries.</P> <P>How to clean a postal code data value by inserting valid postal codes from an external catalog?</P> <P>thanks and best regards</P> Sat, 16 Nov 2024 04:43:37 GMT Anonymous 2024-11-16T04:43:37Z https://community.qlik.com/t5/Data-Quality/How-to-load-valid-data-catalogs-for-data-profiling-and-data/m-p/2262262#M1741 <P>Hi everybody,</P> <P>I have CSVs and relational tables with names, adresses, postal codes, phones, etc.</P> <P>In the case of data profiling with TOS Data Quality AND Data Preparation:</P> <P>How could I aggregate local valid postal codes and street names to Talend?</P> <P>The postal codes in TOS Data Quality are from different countries.</P> <P>How to clean a postal code data value by inserting valid postal codes from an external catalog?</P> <P>thanks and best regards</P> Sat, 16 Nov 2024 04:43:37 GMT https://community.qlik.com/t5/Data-Quality/How-to-load-valid-data-catalogs-for-data-profiling-and-data/m-p/2262262#M1741 Anonymous 2024-11-16T04:43:37Z https://community.qlik.com/t5/Data-Quality/How-to-load-valid-data-catalogs-for-data-profiling-and-data/m-p/2262263#M1742 <P>Hello,</P> <P>If you have the whole address in your record, and if you deal with geographical addresses, tGoogleAddressRow will meet your needs.</P> <P><A title="TalendHelpCenter:tGoogleAddressRow" href="https://help.talend.com/reader/50xCvEErGAlUhlym_NNf5A/qSxMbmwLwi2_Djma9bFHaA" target="_self" rel="nofollow noopener noreferrer">TalendHelpCenter:tGoogleAddressRow</A>&nbsp;</P> <P>It converts human-readable addresses into geographic coordinates and other geographic information.</P> <P>This component is available in <A class="xref ft-external-link" href="https://www.talend.com/products/data-integration/data-management-platform/?utm_medium=help&amp;utm_source=help_content" target="_blank" rel="noopener nofollow noopener noreferrer">Talend Data Management Platform</A>, <A class="xref ft-external-link" href="https://www.talend.com/products/big-data/big-data-platform/?utm_medium=help&amp;utm_source=help_content" target="_blank" rel="noopener nofollow noopener noreferrer">Talend Big Data Platform</A>, <A class="xref ft-external-link" href="https://www.talend.com/products/big-data/real-time-big-data/?utm_medium=help&amp;utm_source=help_content" target="_blank" rel="noopener nofollow noopener noreferrer">Talend Real Time Big Data Platform</A>, <A class="xref ft-external-link" href="https://www.talend.com/products/application-integration/data-services-platform/?utm_medium=help&amp;utm_source=help_content" target="_blank" rel="noopener nofollow noopener noreferrer">Talend Data Services Platform</A>, <A class="xref ft-external-link" href="https://www.talend.com/products/mdm/mdm-platform/?utm_medium=help&amp;utm_source=help_content" target="_blank" rel="noopener nofollow noopener noreferrer">Talend MDM Platform</A> and <A class="xref ft-external-link" href="https://www.talend.com/products/data-fabric?utm_medium=help&amp;utm_source=help_content" target="_blank" rel="noopener nofollow noopener noreferrer">Talend Data Fabric</A>.</P> <P>Best regards</P> <P>Sabrina</P> Tue, 08 Oct 2019 09:02:54 GMT https://community.qlik.com/t5/Data-Quality/How-to-load-valid-data-catalogs-for-data-profiling-and-data/m-p/2262263#M1742 Anonymous 2019-10-08T09:02:54Z