Mapping information (field information)

Condition No.

Extraction condition number is displayed in Condition name n (n = Condition number) format.

Output file No.

The output file number is displayed in Output file n (n = Output file number) format.

Comment

Displays comments on the condition and the output file.

Field Name

The name of the field.

Field number

The number of the field.

Comments

Comment on the input field.

Fixed/Variable length

The definition of the field length.

Displays Variable length (delimiter specified) when it is variable length for Format, Multi Format, or Hierarchy Format.

No. of occurrences

The number of occurrences of the field.

No. of bytes

The number of bytes of the field.

Digits after decimal point

Number of digits after the decimal point of the field

Field type

The data type for the relevant field.

This is the same meaning as Field type of the format information.

Input delimiter

The specification of the delimiter for input side.

This item is displayed only if Fixed/Variable length is set to Delimiter specified.

Input delimiter value

The specification of the delimiter value for input side.

This item is displayed only if Input delimiter is set to Add.

Output delimiter

The specification of the delimiter for output side.

This is a display when specified as output side, so it does not have specific meaning.

Output delimiter value

The specification of the delimiter value for output side.

This is a display when specified as output side, so it does not have specific meaning.

Constant

Displayed when browse field name is used.

Multiple

Displayed when browse field name is used.

Reference field name

The name of the field to store the data length.

This item is displayed only if Fixed/Variable length is set to Field name specified.

name

The name of the field.

type

The type of the field.

Character data or numeric value.

minOccurs

The minimum value for occurrence frequency.

maxOccurs

The maximum value for occurrence frequency.

default

The default value of the field.

empty

The empty element flag of the field.

true

: Defined as an empty element.

false

: Not defined as an empty element.

Cell

The name of a single cell in Excel information.

Column

The name of a column in Excel information.

Format ID

The Format ID of the record.

Displayed when Record name is selected.

No-hit behavior

The behavior when the input data did not match the occurrence key.

Displayed when Record name is selected.

Error

: Treated as an error.

Use the default value

: Uses the record of the default values set for the field types of each field.

Treat as normal and use previous data

: Reuses the values used for processing the previous time in the relevant record. Uses the default values for each field type when processing the relevant record for the first time.

Maximum number of occurrences

The maximum number the group is repeated.

Displayed when the Group name that has set something other than Field name for Maximum no. of occurrences (type) is selected.

Record containing the number of occurrences

The record name including fields that store the maximum number of group occurrence.

Displayed when the Group name that has set Field name for Maximum no. of occurrences (type) is selected.

Field containing the number of occurrences

The field name storing the maximum number of group occurrence.

Displayed when the Group name that has set Field name for Maximum no. of occurrences (type) is selected.

Variable name

The name of the variable.

Displayed when variable for input side is selected.

Variable type

The type of the variable.

Character string or Numeric value. Displayed when variable for input side is selected.

Initial value

Displayed when variable for input side is selected.

Field name

The name of the field.

Comment

Comment on the output field.

Field No.

The number of the field.

Fixed/Variable length

Definition of the field length

Displays Delimiter specified or Field name specified when it is variable length for Format or Multi Format.

No. of occurrences

The number of occurrences of the field.

No. of bytes

The number of bytes of the field.

Initial number of bytes is used when omitted.

This item is displayed only if Format for the output side is Database Table. Indicates the maximum number of bytes when it is variable length.

Digits after decimal point

Number of digits after the decimal point of the field

Initial number of digits after decimal point is used when omitted.

Cell

The name of a single cell in Excel information.

Column

The name of a column in Excel information.

Field type

The data type for the relevant field.

This is the same meaning as Field type of the format information. Initial field type is used when omitted.

Initial number of bytes

The initial number of bytes for the field.

Initial number of digits after decimal point

The Initial number of digits after decimal point for the field.

Initial field type

The initial type for the field.

This is the same meaning as Field type of the format information.

Input delimiter

The specification of the delimiter for input side.

This item is displayed only if Fixed/Variable length is set to Delimiter specified.

This is a display when specified as input side, so it does not have specific meaning.

Input delimiter value

This item is displayed only if Input delimiter is set to Add.

This is a display when specified as input side, so it does not have specific meaning.

Output delimiter

The specification of the delimiter for output side.

Output delimiter value

The specification of the delimiter value for output side.

Constant

The constant for the data length calculation formula.

Displayed when the Fixed/Variable length is set to Field name specified.

This is a display when specified as input side, so it does not have specific meaning.

Multiple

The multiple for the data length calculation formula.

Displayed when the Fixed/Variable length is set to Field name specified.

This is a display when specified as input side, so it does not have specific meaning.

Reference field name

The name of the field to store the data length.

Displayed when the Fixed/Variable length is set to Field name specified.

This is a display when specified as input side, so it does not have specific meaning.

name

The name of the field.

type

The type of the field.

Character data or Numeric value.

minOccurs

The minimum value for occurrence frequency.

maxOccurs

The maximum value for occurrence frequency.

default

The default value of the field.

empty

The empty element flag of the field.

true

: Defined as an empty element.

false

: Not defined as an empty element.

Handling of trailing spaces after character data

Specify how to handle trailing spaces after character data.

Same as output settings

: Complies to the setting of the output file.

Trim

: Processes with trimming the space after.

Do not trim

: Processes without trimming the space after.

Compress

: Processes with trimming the space after. Processes by compressing to single-byte halfwidth space code when the data is space only.

Handling of leading zeros in numeric data

Specify how to handle leading zeros in numeric data.

If Format for output side is CSV or XML (numeric fields), specify this item.

Same as output settings

: Complies to the setting of the output file.

Trim

: Processes with trimming leading zeros.

Do not trim

: Processes without trimming leading zeros.

Add a zero (0)

: A zero (0) is added to the front of the numeric value data.

Add a plus sign (+)

: A plus sign (+) is added to the front of the numeric value data.

Concatenation sequence

The sequence of usage of field in the SQL statement.

Key

The flag that indicates whether it is a key.

Fullwidth and halfwidth kana conversion

The conversion method between the halfwidth Kana character and the fullwidth Kana characters for the field value.

If the output data type is M, W, CSV character string, XML character string, or TXT character string, specify this item. For details, see DataMagic Operation Manual.

Same as output settings

: Complies to the setting of the output file.

Do not convert

: Will not convert.

Convert halfwidth to fullwidth

: Converts halfwidth kana characters to fullwidth kana characters.

Convert fullwidth to halfwidth

: Converts fullwidth kana characters to halfwidth kana characters.

Conversion of fullwidth and halfwidth alphanumeric characters

Fullwidth and halfwidth alphanumeric conversion

If the output data type is M, W, CSV character string, XML character string, or TXT character string, specify this item. For details, see DataMagic Operation Manual.

Same as output settings

: Complies to the setting of the output file.

Do not convert

: Will not convert.

Convert halfwidth to fullwidth

: Converts halfwidth alphanumeric to fullwidth alphanumeric.

Convert fullwidth to halfwidth

: Converts fullwidth alphanumeric to halfwidth alphanumeric.

Fullwidth and halfwidth symbol conversion

The conversion method between the halfwidth symbol and the fullwidth symbol for the field value.

If the output data type is M, W, CSV character string, XML character string, or TXT character string, specify this item. For details, see DataMagic Operation Manual.

Same as output settings

: Complies to the setting of the output file.

Do not convert

: Will not convert.

Convert halfwidth to fullwidth

: Converts halfwidth symbol to fullwidth symbol.

Convert fullwidth to halfwidth

: Converts fullwidth symbol to halfwidth symbol.

Handling of 0-byte input data

The conversion method of Null (0 bytes) in the input data.

Same as output settings

: Complies to the setting of the output file.

Default value

: Converts to the default value for each data type. For details about the default value of the data type, see DataMagic Operation Manual.

Null

: Converts to Null value.

Variable name

The name of the variable.

Displayed when variable for output side is selected.

Variable type

The type of the variable.

Character string or Numeric value.

Displayed when variable for output side is selected.

Initial value

Displayed when variable for output side is selected