Configuring the output component and executing the Job
-
Double-click the tFileOutputExcel
component to display the Basic settings
view and define the component properties.
-
Set the destination file name as well as the sheet name and then select
the Define all columns auto size check
box. -
Save your Job and press F6 to execute
it.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 the Loqate repository.The all_info and Geo_info
columns retrieve additional address information from the
Raw_Response and GeoAccuracy
columns respectively in the Loqate repository. The
Raw_Response column provides you with all address
information from the provider repository without any formatting. if you want
this information to be more readable, you must parse it using json or
xml.TheSTATUSoutput column returns theOKstatus
for all address rows. This means that the verification process of all
address rows could be completed successfully by the component. For further
information about process status, see Process status in tLoqateAddressRow.The VerificationLevel output column
provides you with a verification status of the processed addresses. For
further information, see Verification status.The AddressVerificationCode output column
returns a verification code for each of the processed address rows. For
example, the first verification codeV44-I45-P3-100
means:-
Verification status = V (verified): a complete match was made
between the input address and a single record from the available
reference data. -
Post-processed verification match level = 4 (premises): the level
to which the input data matches the available reference data once
all changes and additions performed during the verification process
have been taken into account. -
Pre-processed verification match level = 4 (premises): the level
to which the input data matches the available reference data prior
to any changes or additions performed during the verification
process. -
Parsing status = I (identified and parsed): all components of the
input data have been able to be identified and placed into output
fields. -
Lexicon identification match level = 4 (premises): using pattern
matching, a numeric value or word has been identified as a premises
number or name. -
Context identification match level = 5 (delivery point, PostBox or
SubBuilding): a numeric value or word has been identified as a post
box number or sub building name. -
Postcode Status = P3 (added): the primary postal code for the
country has been added. -
Match score = 100 (complete similarity): the input data and
closest reference data match completely.
For further information about what values this code is made up of and the
implications of each segment, see Address verification codes in tLoqateAddressRow. -