Warning
This component will be available in the Palette of
Talend Studio on the condition that you have subscribed to one of
the Talend Platform products.
The address management components discussed here are the result of Talend
collaboration with Experian QAS, one of the world leaders for global address data quality.
For more information about the enterprise and its software tools, visit http://www.qas.com.
|
Component family |
Data Quality |
|
|
Function |
tQASAddressRow verifies columns tQASAddressRow uses QAS Pro Web |
|
|
Purpose |
tQASAddressRow corrects any For more information about the verification status, see QuickAccess verification levels (verification status). |
|
|
Basic settings |
QAS WSDL url |
Enter the URL for the QuickAdress XML document (provided by |
|
|
Country |
Select from the list the country corresponding to your input |
|
|
Schema and Edit |
A schema is a row description, it defines the number of fields to Since version 5.6, both the Built-In mode and the Repository mode are |
|
|
|
Built-in: You create the schema |
|
|
|
Repository: You have already |
|
|
Column |
Select from the list the address column you want to |
|
Advanced settings |
tStat |
Select this check box to collect log data at the component |
|
Global Variables |
NB_LINE: the number of rows read by an input component or ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see Talend Studio |
|
|
Usage |
This component is an intermediary step. It requires an input flow |
|
|
Limitation |
n/a |
|
An address can be matched to one of six verification levels. These verification levels
are directly returned by the tQASAddressRow component
to indicate the returned match type of the checked addresses. Moreover, the output flows
of the other QAS components are adapted to match to one or more of the below
verification levels.
The six QuickAddress verification levels are:
-
Verified: The address searched upon is matched to a single deliverable
address in the QuickAddress data. The verified result may be slightly different
from the address entered and searched upon, as any formatting and spelling
errors will have been corrected, and any missing elements will have been added.
When this match type is returned, no further user interaction is
required. -
Interaction required: The address searched upon is matched to a single
deliverable address in the QuickAddress data, although there is less confident
about the match than for the verified level above, and
therefore user interaction is recommended to confirm that it is the correct
address. -
PremisesPartial: The address searched upon is not matched
to a complete deliverable result in the QuickAddress data, and instead has been
matched to a partially-complete address.For example, the address is matched to a premises in the QuickAddress data,
but a complete deliverable match could not be found: “63 Southerton Road,
London” rather than “Flat A, 63 Southerton Road, London”. -
StreetPartial: The address searched upon is not matched
to a complete deliverable result in the QuickAddress data, and instead has been
matched to a partially-complete address.For example, the address is matched to a street in the QuickAddress data, but
a complete deliverable match could not be found: “Kew Road, Richmond” rather
than “88 Kew Road, Richmond”. -
Multiple: The address searched upon is not matched to a
single deliverable result in the QuickAddress data, and instead has matched
equally to more than one result.For example, the address is matched to two equally valid addresses that can
only be distinguished by address information that has not been provided in the
search.user interaction is therefore necessary to select the required
address. -
None: The address searched upon could not be matched to
any deliverable results in the QuickAddress data. When this match type is
returned, no address verification is possible and the submitted address should
be used instead.
Below is a five-component Job created in Talend Studio.
This Job:
-
reads an input csv file that holds some client-related information,
-
uses the tMap component to concatenate the
three fields Address, Postal, and City
from the incoming data flow in one output column:
Edit_Address, -
uses the tQASAddressRow component to analyze
the output column Edit_Address and gives the verification
status of all edited addresses, -
uses a tFilterRow component to output only
the addresses which status is not equal to None. -
and finally displays the correct formatted address along with their
verification status on the console.
In this scenario, we have already stored the input schema of the input file in the
Repository. For more information about storing schema metadata in the Repository tree view, see Talend Studio User
Guide.
-
In the Repository tree view, expand
Metadata and the file node where you
have stored the input schemas and drop the relevant file onto the design
workspace.The [Components] dialog box
displays.
-
Select tFileInputDelimited from the list
and click OK to close the dialog
box.The tFileInputDelimited component
displays on the workspace. The input file used in this scenario is called
address_template, which is a csv file that holds
some French client personal information. -
Drop the following components from the Palette onto the design workspace: tMap, tQASAddressRow,
tFilterRow, and tLogRow. -
Connect tFileInputDelimited to tMap and tQASAddressRow to tFilterRow using Main
links, tMap to tQASAddressRow using the New
Output link, and tFilterRow
to tLogRow using the Filter link.
-
Double-click the tMap component to open
the Map Editor and concatenate the
Address, Postal, and City
fields from the incoming data flow in one output column:
Edit_Address.
When done, click OK to close the
Map Editor and propagate the changes to
the next component. -
Double-click the tQASAddressRow component
to display its Basic settings and define
its properties.
-
In the QAS WSDL url field, enter the URL
for the QuickAdress XML document (provided by Experian QAS). -
On the Country list, select the country
corresponding to your input addresses, France in this
example. -
If needed, click Edit schema to view the
input and output data flow. The output schema should include the
Edit_Address column that hold the
Address, Postal, and City
initial input columns.The output schema of any of the QuickAddress components depends on the
selected country in the Country list since
every country has different address norms.
Click OK to close the dialog box.
-
On the Column to analyze list, select
Edit_Address. -
Double-click the tFilterRow component to
display its Basic settings view and define
its properties.
-
In the Conditions area, click the plus
button to add one condition to the output flow and in the corresponding
table cells:-select the input column you want to operate on,
-select the needed function on the list,
-select the operator to bind the input column with the value,
-type in between the quotes the address value to be filtered.
In this example, we want to exclude the addresses which status is equal to
None. -
Double-click the tLogRow component to
display its Basic settings and define its
properties.
In this example, and for clarity purposes, we want the result to display
on the console in a separate key/value tabular list for each row.
