Below is a five-component Job created in Talend Studio.
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.