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
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
|
Value condition |
Required |
Not available |
Select a value condition.
= Remarks =
For details, refer to Value condition list. |
|
Column list |
Required |
- |
Specify the columns. Each column can be operated with the following buttons:
|
|
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. |
|
Update column list |
The first row of the file specified in Expected CSV file path is set as a column name. |
|
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). |
|
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.
|
|
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:
|
|
Value conditions for specific columns/Column name |
Required |
Not available |
Select a column name to apply the condition. |
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.
For schema structure, refer to Table model type .
Output schema
None.
Loading schema in Mapper
The schema is loaded automatically.
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. |
|
message_code |
When an error occurs, the code of the message code corresponding to the error is stored. |
|
message_level |
When an error occurs, the severity of the message code corresponding to the error is stored. |
|
error_type |
When an error occurs, the error type is stored. |
|
error_message |
When an error occurs, the error message is stored. |
|
error_trace |
When an error occurs, the trace information for the error is stored. |
|
-
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 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. |