tUniservRTConvertName (deprecated)

Analyzes the name elements in an address .

tUniservRTConvertName analyzes the
name line against the context and provides the basis for structuring and populating person and
company names in the database. For individual persons, it divides the name line into segments
(name, first name, title, name prefixes, name suffixes, etc.) and creates the address key.

The component recognizes company or institution addresses and is able to
provide the form of the organization separately. It divides lines that contain information on
several persons and is able to recognize certain patterns that do not belong to the name
(customer number, handling notes, etc.) and remove them or move them to special memo
fields.

tUniservRTConvertName Standard properties

These properties are used to configure tUniservRTConvertName running in the Standard Job framework.

The Standard
tUniservRTConvertName component belongs to the Data Quality family.

Basic settings

Schema and Edit schema	A schema is a row description. It defines the number of fields (columns) to be processed and passed on to the next component. When you create a Spark Job, avoid the reserved word `line` when naming the fields. Click Edit schema to make changes to the schema. If the current schema is of the Repository type, three options are available: View schema: choose this option to view the schema only. Change to built-in property: choose this option to change the schema to Built-in for local changes. Update repository connection: choose this option to change the schema stored in the repository and decide whether to propagate the changes to all the Jobs upon completion. If you just want to propagate the changes to the current Job, you can select No upon completion and choose this schema metadata again in the Repository Content window.
Host name	Server host name between double quotation marks.
Port	Listening port number of the server between double quotation marks.
Service	The service type/name is `"cname_d"` by default. Enter a new name if necessary (e.g. due to service suffix), between double quotation marks. Available services: Germany `"cname_d`” Italy `"cname_i"` Austria `"cname_a"` Netherlands `"cname_nl"` Switzerland `"cname_ch"` Belgium `"cname_b"` France `"cname_f"` Spain `"cname_e"`
Use rejects	Select this option to separately output data sets from a certain result class of the onward name analysis. Enter the respective result class in the field if result class is greater or equal to. If this option is not selected, the sets are still output via the Main connection even if the analysis failed. If the option is selected, but the Rejects connection is not established, the sets are simply sorted out when the analysis failed.

Advanced settings

Analysis Configuration	For detailed information, please refer to the Uniserv user manual convert-name.
Output Configuration	For detailed information, please refer to the Uniserv user manual convert-name.
Configuration of not recognized input	For detailed information, please refer to the Uniserv user manual convert-name.
Configuration of free fields	For detailed information, please refer to the Uniserv user manual convert-name.
Cache Configuration	For detailed information, please refer to the Uniserv user manual convert-name.

Global Variables

Global Variables	NB_LINE: the number of rows read by an input component or transferred to an output component. This is an After variable and it returns an integer. ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box. A Flow variable functions during the execution of a component while an After variable functions after the execution of the component. To fill up a field or expression with a variable, press Ctrl + Space to access the variable list and choose the variable to use from it. For further information about variables, see Talend Studio User Guide.

NB_LINE: the number of rows read by an input component or
transferred to an output component. This is an After variable and it returns an
integer.

ERROR_MESSAGE: the error message generated by the
component when an error occurs. This is an After variable and it returns a string. This
variable functions only if the Die on error check box is
cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable
functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl +
Space to access the variable list and choose the variable to use from it.

For further information about variables, see
Talend Studio

User Guide.

Usage

Usage rule	tUniservRTConvertName provides the basis for a uniform structuring and population of person and company names in the database as well as the personalized salutation.
Limitation	To use tUniservRTConvertName, the Uniserv software convert-name must be installed.

Analyzing a person’s name and assigning a salutation

This scenario describes a batch job that analyzes the person names in a file and
assigns them a salutation.

The input file for this scenario is already saved in the Repository, so that all schema metadata is available.

Note:

Please observe that the data from the input source must all be related to the same
country.

Procedure

In the Repository view, expand the Metadata node and the directory in which the file is
saved. Then drag this file into the design workspace.

The dialog box below appears.
Select tFileInputDelimited and then click
OK to close the dialog box.

The component is displayed in the workspace. The file used in this scenario is
called SampleAddresses..
Drag the following components from the Palette into the design workspace: two tMap components, tUniservRTConvertName, and tFileOutputDelimited..
Connect tMap with tUniservRTConvertName first.

Accept the schema from tUniservRTConvertName
by clicking Yes on the prompt window.
Connect the other components via Row >
Main.
Double-click tMap_1 to open the schema
mapping window. On the left is the structure of the input file, on the right is
the schema of tUniservRTConvertName. At the
bottom lies the Schema Editor, where you can
find the attributes of the individual columns and edit them.
Assign the columns of the input source to the respective columns of tUniservRTConvertName. For this purpose, select a
column of the input source and drag it onto the appropriate column on the right
side. If fields from the input file are to be passed on to the output file, like
the address fields or IDs, you have to define additional fields.
Click OK to close the dialog box.
Double-click tUniservRTConvertName to open
its Basic Settings view.
Fill in the server information and specify the country-specific
service.
Double-click tMap_3 to open the mapping
window. On the left is the schema of tUniservRTConvertName and on the right is the schema of the
output file.
Click OK to close the window.
Double-click tFileOutputDelimited and enter
the details for the output file.

Document get from Talend https://help.talend.com

Thank you for watching.

Docs 7.x

0 Comments

Inline Feedbacks

View all comments

tUniservRTConvertName (deprecated) – Docs for ESB 7.x