About this task
You can run the Parsing addresses against reference data in the Cloud Job against Google Places API by doing the followings:
In the tFixedFlowInput
Basic settings, create the schema through
the Edit Schema button.
In the open dialog box, click the [+] button and add one column that will hold the information in the input address, in this example: address.
An address column is created in the Inline Table.
In the Inline Table table, enter the
address data you want to analyze, for example:
"1211 AVENUE OF AMERICAS FL 8 10036 NEW YORK USA" "B69 2lt 9kings United Kingdom ave" "1729号 黄兴路 China, 200433" "15 Rue Nelaton Paris PARIS 92800 France" "1211 AVENUE OF AMERICAS FL 8 10036 NEW YORK" "1 Rue de l'Abbaye, Paris" "1 Chemin de l'Abbaye, Paris" "1 Place de l'Abbaye basset, Paris" "8000 Cummings Hall,Hanover,New Hampshire,03755,"
In the basic settings of tAddressRowCloud, select Google
from the Address Provider list.
- In the License/API key field, enter the API key you generate from the Google Developer Console at https://developers.google.com/console/help/new/.
In the Mapping table, click the [+]
button to add a line and then select Address.
The component will map the values of this field to the input column you set in this table.
If required, select the Use Additional
Output check box and use the Output
Mapping table to retrieve additional address information from
the provider repository.
For further information, see Defining additional address fields.
- In the Advanced settings view, set Output Script to FRENCH and leave the other parameters unchanged.
Save your Job and press F6 to execute
The tAddressRowCloud component uploads data to the cloud, retrieves the corrected data and writes the result in the output file.
Right-click the output component and select Data
Viewer to display the formatted address data.
tAddressRowCloud matches input address data against Google Places API and writes formatted addresses in the output file.The VerificationLevel output column provides you with a verification status of the processed addresses. For further information, see Address verification levels in tAddressRowCloud.