Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2019-09-09 10:00 PM

How to load valid data catalogs for data profiling and data cleansing?

Hi everybody,

I have CSVs and relational tables with names, adresses, postal codes, phones, etc.

In the case of data profiling with TOS Data Quality AND Data Preparation:

How could I aggregate local valid postal codes and street names to Talend?

The postal codes in TOS Data Quality are from different countries.

How to clean a postal code data value by inserting valid postal codes from an external catalog?

thanks and best regards

Labels (3)
Labels
185 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2019-10-08 05:02 AM
Author

Hello,

If you have the whole address in your record, and if you deal with geographical addresses, tGoogleAddressRow will meet your needs.

TalendHelpCenter:tGoogleAddressRow 

It converts human-readable addresses into geographic coordinates and other geographic information.

This component is available in Talend Data Management Platform, Talend Big Data Platform, Talend Real Time Big Data Platform, Talend Data Services Platform, Talend MDM Platform and Talend Data Fabric.

Best regards

Sabrina

185 Views
0 Likes