Detailed condition settings (for matching between matching files)

(1) Matching fields (left)

Specify the fields in the matching file used to set matching conditions.

Parentheses containing a number are displayed after Matching field. This number corresponds to the matching setting number of the relation line drawn in the input file area.

Note

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

Field No.

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

Note

The fields of type I cannot be specified.

Browse button

Displays the Select Field screen corresponding to the matching target. From this displayed screen, select the field record to be registered, and then click the OK button. Click the Cancel button if you do not wish to select anything.

No. of occurrences

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

This field is not displayed if Format in the matching target is CSV or Excel.

Field type

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

This field is not displayed if Format in the matching target is CSV.

(2) Operator

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

When "Character string" is selected for "Type"

  • Begins with

    This means that the value in the comparison source matching file matches the beginning portion of the value in the comparison target matching file.

  • Ends with

    This means that the value in the comparison source matching file matches the end portion of the value in the comparison target matching file.

  • Contains

    The value of the comparison source matching file is included in the value of the comparison target matching file.

  • Equals

    The value of the comparison source matching file is completely matching with the value of the comparison target matching file.

  • Not equal

    The value of the comparison source matching file does not match with the value of the comparison target matching file.

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

  • <

    The value of the comparison source matching file is less than the value of the comparison target matching file.

  • >

    The value of the comparison source matching file is greater than the value of the comparison target matching file.

  • <=

    The value of the comparison source matching file is less than or equal to the value of the comparison target matching file.

  • >=

    The value of the comparison source matching file is greater than or equal to the value of the comparison target matching file.

  • ==

    The value of the comparison source matching file is equal to the value of the comparison target matching file.

  • !=

    The value of the comparison source matching file is not equal to the value of the comparison target 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 source matching file is longer than the target matching file. Specify the length of the data based on the following:

    The matching target 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 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 settings is CSV or Excel.

Field type

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

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

See Field type in 3.3.2 Fields settings.Fields settings