Description of Table Recode Arguments - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

This table lists values and examples of each argument in the Table Recode settings. The arguments are listed in the order of appearance in the TABLE_RECODING parameter.

Argument Description
ENTRY_ID

(REQUIRED) Specifies a block of settings in the settings file.

Values

Numeric value.

Example

<ENTRY>

<ENTRY_ID>1</ENTRY_ID>

ENTRY_DESCRIPTION

(OPTIONAL) Used to enter descriptions of certain functions. For each description, you can use alphabetic or numeric input, with a 100-byte limit. If this argument is not defined, a No Description Specified message displays in the description column of the statistics file.

Format

ENTRY_DESCRIPTION <description>

Values

Alpha and numeric.

Example

<ENTRY_DESCRIPTION>Convert a to A</ENTRY_DESCRIPTION>

FILE_QUALIFIER

(REQUIRED) Specifies a name given to a recode table. This argument can be used to link attributes specified in conditional statements to the appropriate entity.

Values

User-defined file identifier.

Example

<FILE_QUALIFIER>OUTPUT1</FILE_QUALIFIER>

TABLE_FILE_NAME

(REQUIRED) Name of the table that the Transformer uses for recoding purposes.

Values

File name.

Note: The table name can only contain Latin1 characters.

Example

<TABLE_FILE_NAME>..\tables\recode_table.csv</TABLE_FILE_NAME>

DDL_FILE_NAME

(REQUIRED) Specifies the name of the Data Dictionary Language (DDX) file associated with the recode table.

Values

A DDX file name.

Example

<DDL_FILE_NAME>..\ddl\recode_table.ddx</DDL_FILE_NAME>

FILE_DELIMITER_ENCODING

(OPTIONAL) The encoding for interpreting literal characters specified in FILE_DELIMITER. If not specified, the default is the platform’s native encoding.

Values

Encoding table.

Example

<FILE_DELIMITER_ENCODING>cp1252</FILE_DELIMITER_ENCODING>

FILE_DELIMITER

(OPTIONAL) Delimiters used to separate data fields in a recode table.

Values

Comma, space or tab, but any other character can also be used.

Example

<FILE_DELIMITER>tab</FILE_DELIMITER>

USE_QUOTES_AS_QUALIFIER

#

DELIMITED_FILE_COMMENT_INDICATOR

(OPTIONAL) Comment characters used to ignore lines in a recode table. The Transformer will ignore any lines in the recode table that start with the character specified in this option. If you do not specify this argument, the comment character is '#' by default. If your table has no comments, specify "" which turns off the default comment character ('#').

Note: This argument only applies to delimited tables.

Values

"", # or *, but any other character can also be used.

Example

<DELIMITED_FILE_COMMENT_INDICATOR>$</DELIMITED_FILE_COMMENT_INDICATOR>

LOOKUP_PHRASE_SEPARATOR

#

LOOKUP_PHRASE_CHANGE

(OPTIONAL) Recode only the matched string. When this option is not selected, the entire attribute will be changed. This option is typically used to set a flag in a different attribute whenever a specified value is found in the input data.

Values

Y
Change only the matched string.
N
Change the entire attribute.

Example

<LOOKUP_PHRASE_CHANGE>Y</LOOKUP_PHRASE_CHANGE>

LOOKUP_POSITION

(OPTIONAL) Specify a position of the phrase separator.

Values

B
Beginning of phrase
E
End of phrase
D
Anywhere

Example

<LOOKUP_POSITION>B</LOOKUP_POSITION>

LOOKUP_TABLE_FIELDS

(REQUIRED) Contains a list of fields from a recode table. The data in these fields is looked up for recoding purposes.

Note: You can specify up to five attributes. Separate multiple attributes by commas.

Values

Field name(s).

Example

<LOOKUP_TABLE_FIELDS>city, state</LOOKUP_TABLE_FIELDS>

LOOKUP_FIELDS_CASE_SENSITIVE

(OPTIONAL) Enables or disables the case-sensitive table lookup. By default, the lookup is case insensitive; for example, "Rick" will match "RICK" or "riCK".

Values

Y
Enables the case-sensitive table lookup.
N
Disables the case-sensitive table lookup (default).

Example

<LOOKUP_FIELDS_CASE_SENSITIVE>Y</LOOKUP_FIELDS_CASE_SENSITIVE>

LOOKUP_OUTPUT_FIELDS

(REQUIRED) A list of attribute from the output entity whose data you want to lookup for recoding purposes.

Note: You can specify up to five attributes. Separate multiple attributes by commas.

Values

Attribute list.

Example

<LOOKUP_OUTPUT_FIELDS>Phone Number, City </LOOKUP_OUTPUT_FIELDS>  

LOOKUP_OUTPUT_FIELDS_FORMAT

(OPTIONAL) Tells the Transformer whether a mask or a literal value will be looked up in the table. These values are comma-separated, one for each attribute specified in LOOKUP_OUTPUT_FIELDS.

Values

Encoding table.

L
Literal (default)
M
Mask

Example

<LOOKUP_OUTPUT_FIELDS_FORMAT>M,L</LOOKUP_OUTPUT_FIELDS_FORMAT>

RECODE_TABLE_FIELDS

(REQUIRED) A comma-separated list of DDX fields from the recode table DDX. They define the data to be stored in the output location(s) defined by RECODE_ OUTPUT_ FIELDS when there is a match from the data in the output entity to the recode table.

Values

Field names.

Example

<RECODE_TABLE_FIELDS>Recode Name</RECODE_TABLE_FIELDS>

RECODE_TABLE_FIELDS_FORMAT

(OPTIONAL) The format of the specified table fields. Comma separated values, one for each table field specified in the RECODE_TABLE_FIELDS argument.

Values

L
Literal (default)
M
Mask

Example

RECODE_TABLE_FIELDS_FORMAT>L, M</RECODE_TABLE_FIELDS_FORMAT>

RECODE_OUTPUT_FIELDS

(REQUIRED) Attribute name(s) from the output DDX that define the locations in the output record to store the recode value from the recode table.

Note: You can specify up to five attributes. Separate multiple attributes by commas.

Values

Attribute names.

Example

<RECODE_OUTPUT_FIELDS>name</RECODE_OUTPUT_FIELDS