Compare Table Model

Operation name

Compare Table Model

Function overview

Compares the table model type data of the input source with the expected values of the CSV file based on specified conditions.

Data model

The data model of this component is table model type.

Properties

= Remarks =

For details on use of variables, refer to Variables.

Basic settings

Item name

Required/Optional

Use of variables

Description

Remarks

Name

Required

Not available

Enter a name that is used on the script canvas.

 

Input data

Required

Not available

Select a component on the script canvas.

 

Required settings

Item name

Required/Optional

Use of variables

Description

Remarks

Expected CSV file path

Required

Available

Enter the CSV file path to use as expected values for conditions.

The Browse button launches a file chooser that allows you to select a file.

Note
  • The expected CSV file path must be in CSV format.

  • Specify an absolute path of HULFT Square Storage for the file path.

  • With the exception of the path separator "/", the Restricted characters of HULFT Square Storage can't be used.

Value condition

Required

Not available

Select a value condition.

= Remarks =

For details, refer to Value condition list.

  • For columns where conditions are defined in Value conditions for specific columns, the conditions in Value conditions for specific columns will be applied instead of this property item.

Column list

Required

-

Specify the columns.

Each column can be operated with the following buttons:

Up

Moves the selected column upward by one row.

Down

Moves the selected column downward by one row.

Add

Adds a column.

Delete

Deletes the column.

  • Column names set in Column list will be displayed in Mapper schema.

Column list/Column name

Required

Available

Enter the column name.

The first row of the file specified in Expected CSV file path can be set as a column name using the Update column list property action.

 

Property actions

Item name

Description

Remarks

Preview

The previewer is started, and the contents of the file specified in Expected CSV file path is displayed.

  • Disabled when the specified file doesn't exist or a variable is set in Expected CSV file path.

  • The contents are displayed with the encoding specified in Preview Character Set.

  • The contents of the file can't be edited.

  • The maximum file size that can be displayed in the previewer is 1MB. If the file size exceeds 1MB, the contents up to 1MB from the beginning of the file will be displayed.

Update column list

The first row of the file specified in Expected CSV file path is set as a column name.

  • Disabled when the specified file doesn't exist or a variable is set in Expected CSV file path.

Read column names from first row of file

Select a file in file chooser, and the first row of that file is set as a column name.

 

Read settings

Item name

Required/Optional

Use of variables

Description

Remarks

Encoding

Required

Available

Select or enter an encoding for the file to read.

When you enter encoding, specify one of the encodings supported in Java SE Runtime Environment 8.

= Remarks =

For details, refer to "Supported Encodings" (http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html).

  • The default encoding selected for Encoding of file type connectors is UTF-8.

Do not get first row as value

Optional

Not available

Select whether or not to handle the first row of the specified file as data.

Selected

Don't handle as data.

Not selected

(Default)

Handle as data.

 

Comparison detail settings

Item name

Required/Optional

Use of variables

Description

Remarks

Row condition

Required

Not available

Select a row condition.

Value conditions for specific columns

Optional

-

Specify a condition by selecting a value condition individually.

Each column can be operated with the following buttons:

Up

Moves the selected column upward by one row.

Down

Moves the selected column downward by one row.

Add

Adds a column.

Delete

Deletes the column.

 

Value conditions for specific columns/Column name

Required

Not available

Select a column name to apply the condition.

  • The column names set in Column list are displayed.

Note

If you add or delete items in Column list after configuring this property item, reconfigure this property item.

Value conditions for specific columns/Data type

Required

Not available

Select a data type.

Value conditions for specific columns/Value condition

Required

Not available

Select a value condition.

Comment

Item name

Required/Optional

Use of variables

Description

Remarks

Comment

Optional

Not available

You can write a short description of this connector.

 

Schemas

Input schema

The number of columns varies depending on the Column list settings.

= Remarks =

For schema structure, refer to Table model type .

Output schema

None.

Loading schema in Mapper

The schema is loaded automatically.

= Remarks =

For details, refer to Edit Schema.

Parallel Stream Processing

PSP isn't supported.

Available component variables

Component variable name

Description

Remarks

message_category

When an error occurs, the category of the message code corresponding to the error is stored.

  • The default value is null.

message_code

When an error occurs, the code of the message code corresponding to the error is stored.

  • The default value is null.

message_level

When an error occurs, the severity of the message code corresponding to the error is stored.

  • The default value is null.

error_type

When an error occurs, the error type is stored.

  • The default value is null.

  • The format of the error type is as follows.

    Example: java.io.FileNotFoundException

error_message

When an error occurs, the error message is stored.

  • The default value is null.

error_trace

When an error occurs, the trace information for the error is stored.

  • The default value is null.

Specification limits

  • About Value conditions for specific columns/Column name

    • When multiple columns with the same name are set in Column list/Column name and that name is set in Value conditions for specific columns/Column name, the column with the same name at the topmost position in Column list/Column name will be used.

Exception messages

Exception name

Cause

Solution

InvalidPropertyConfigurationException

File path is not entered.

Expected CSV file path isn't specified.

Specify Expected CSV file path.

FileIsDirectoryException

The path entered in Expected CSV file path is a directory.

Enter a file path in Expected CSV file path.

java.io.FileNotFoundException

The file specified in Expected CSV file path doesn't exist.

Check Expected CSV file path.

java.lang.IndexOutOfBoundsException

The number of columns of the input table model type data differs from that of Expected CSV file path.

Make the number of columns of the input table model type data and that of Expected CSV file path same.

AssertionException

The input value and the expected value don't match the conditions.

Check the error message.