About this task
You can run the Parsing addresses against reference data in the Cloud Job using the QAS Pro OnDemand service and verifiy the accuracy and completeness of addresses.
Procedure
-
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.
-
Click OK.
An address column is created in the Inline Table.
-
In the Inline Table table, enter the
address data you want to analyze, for example:
"1 nonsense st, nowhereville, SC,11111" "14 elmwood,rome,ga,30161" "300 n quincy pl, charlestown,MA,02129" "reba st,pelion,SC,29123" "1445 montebello st,montebello,90640" "43400 gadsden ave,lancaster,ca,93534" "po box 123,san francisco,ca,94104" "43400 gadsden ave apt 3,lancaster,ca,93534"
-
In the basic settings of tAddressRowCloud, select QAS
from the Address Provider list.
- From the Country list, select the country corresponding to your input addresses, United States in this example.
- In the QAS OnDemand username and password fields, enter respectively your username and password you can find in the license provided by QAS.
-
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.
- Leave the parameters in the Advanced settings view unchanged.
-
Save your Job and press F6 to execute
it.
The tAddressRowCloud component uploads data to the cloud, validates and 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 validates input address data against QAS Pro OnDemand 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.