Official |[Assertion] 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.

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.

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.	For details, refer to Row condition list.
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.	For details, refer to Data type list.
Value conditions for specific columns/Value condition	Required	Not available	Select a value condition.	For details, refer to Value condition list.

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.