Detailed condition settings (for matching between an input file and a matching file)

(1) Input fields (left)

Specify the fields in the input files used to set matching conditions.

Note

If a field of type I is specified, upon execution, a conversion error occurs. Do not set a field of field type I.

Specification method

Select the specification method of the input file to be matched.

You can select Field name or Field No..

If no CSVID is specified in the layout information, Field No. is selected. Therefore, you must enter Field No..

This field is not displayed if Format in the input settings is CSV and no CSV ID is specified.

Field No.

Specify by using the field number of the input file to be matched. Specify a value from 1 to 1000.

Field name

Specify by using the field name of the input file to be matched.

If Format in the input settings is CSV and no ID is specified, you cannot set this field.

If Format in the input settings is Hierarchy Format, specify the value in the format of <record-name>&<field-name>. Use the Browse button to enter a value.

If Format in the input settings is XML, enter the field name, separating the levels by using a forward slash (/) and using front-zero padding of 4-bytes to enter the number of occurrences immediately after the element name separated by three forward slashes (///). If the field is an attribute, write the attribute name after the element with that attribute, separating them by using two forward slashes (//).

Example: root///0001/parent///0001

Meaning: The value of the child element parent (first) of the root element (first)

Example: root///0001/parent//0001//id

Meaning: The value of the attribute ID of the child element parent (first) of the root element (first)

No. of occurrences

Displays the occurrence number of the field set in Field name or Field No..

If Format in the input settings is CSV, XML, or Excel, this field is not displayed.

Field type

Displays the type of the field set in Field name or Field No.

If Format in the input settings is CSV or XML, this field is not displayed.

(2) Operator

Specify the comparative operator. The operators that you can specify varies depending on the selection made for Type.

When "Character string" is selected for "Type"

  • Begins with

    This means that the value in the input file matches the beginning portion of the value in the matching file.

  • Ends with

    This means that the value in the input file matches the end portion of the value in the matching file.

  • Contains

    The value of the input file is included in the value of the matching file.

  • Equals

    The value of the input file is completely matching with the value of the matching file.

  • Not equal

    The value of the input file does not match with the value of the matching file.

When "Numeric value" or "Date" is selected for "Type"

  • <

    The value of the input file is less than the value of the matching file.

  • >

    The value of the input file is greater than the value of the matching file.

  • <=

    The value of the input file is less than or equal to the value of the matching file.

  • >=

    The value of the input file is greater than or equal to the value of the matching file.

  • ==

    The value of the input file is equal to the value of the matching file.

  • !=

    The value of the input file is not equal to the value of the matching file.

Note

  • If Type is Character string, and if Begins with, Ends with, or Contains is used as the comparative operator, you cannot use an asterisk (*) or external characters as a key value.

    Operations are not guaranteed if you use any platform-dependent characters. If a space exists before or after the key value, the space is handled as a character.

  • If the operator is either Begins with or Ends with, it does not result in a match when the input data is longer than the matching target data. Specify the length of the data based on the following:

    The input fields (on the left) is shorter than the matching target fields (on the right).

(3) Matching fields (right)

Specify matching fields.

Note

If a field of type I is specified, upon execution, a conversion error occurs. Do not set a field of field type I.

Type

Select the matching condition type.

Select the type of field to compare from Character string, Numeric value, and Date. Processing will be performed by determining digits after a decimal point in case of Numeric value. For details about the format that you can specify in Date, see DataMagic Operation Manual.

The types of operator that you can specify vary depending on the selected value.

Note

  • If a numeric value type is in a field of the input file or of the matching file targeted for matching, make sure that you set this field to "Numeric value".

  • If matching is specified in the matching conditions as a numeric value type, this value is internally converted to floating point for comparison. The accuracy will be a maximum of 15 digits for Windows and 16 digits for UNIX/Linux.

Field No.

Specify the fields of the matching-file side to be used for matching condition settings.

If Format in the matching settings is CSV and no ID is specified, enter the field number. In other cases, click the Browse button and select the field.

No. of occurrences

Displays the occurrence number of the field set in Field name or Field No..

This cannot be set if Format in the matching target is CSV or Excel.

Data type

Displays the type of the field set in Field name or Field No..

This cannot be set if Format in the matching target is CSV.

See Field type in 3.3.2 Fields settings.Fields settings