Description of Table Recode Arguments - trillium_discovery - trillium_quality - 17.1

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

Values

Numeric value.

Example

<ENTRY>

<ENTRY_ID>1</ENTRY_ID>

(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>

(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>

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

Values

File name.

Example

<TABLE_FILE_NAME>..\tables\recode_table.csv</TABLE_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>

(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>

(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>

#

(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 ('#').

Values

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

Example

<DELIMITED_FILE_COMMENT_INDICATOR>$</DELIMITED_FILE_COMMENT_INDICATOR>

#

(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>

(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>

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

Values

Field name(s).

Example

<LOOKUP_TABLE_FIELDS>city, state</LOOKUP_TABLE_FIELDS>

(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>

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

Values

Attribute list.

Example

<LOOKUP_OUTPUT_FIELDS>Phone Number, City </LOOKUP_OUTPUT_FIELDS>  

(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>

(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>

(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>