Item name | Required/Optional | Use of variables | Description | Remarks |
---|---|---|---|---|
Name | Required | Not available | Enter the name to show on the script canvas. | |
Input data | Required | Not available | Select a component on the script canvas. |
Item name | Required/Optional | Use of variables | Description | Remarks |
---|---|---|---|---|
Sort key configuration | Required | - | Specify columns which would be the key for sort operation.
Comparison priority for a key set to upper row will be high. Each column can be operated with the following buttons.
|
|
Sort key configuration/Column name | Required | Not available | Select a column name that would be a key. |
|
Sort key configuration/Data type | Required | Not available | Select a data type at the time of sort, when the key column is string.
|
|
Sort key configuration/Order | Required | Not available | Select the order of sort.
|
|
Preserve the initial order of keys with equal values | Optional | Not available | Select whether to preserve the order of the input data or not, when the value of sort key is equal.
|
|
Item name | Required/Optional | Use of variables | Description | Remarks |
---|---|---|---|---|
Configure output manually | Optional | Not available | Select whether or not to set columns to be output manually.
|
|
Output target configuration | Optional | - | Specify columns to be output.
Each column can be operated with the following buttons.
|
|
Output target configuration/Column name | Required | Not available | Select the name of a column to be output. |
|
Item name | Required/Optional | Use of variables | Description | Remarks |
---|---|---|---|---|
Comment | Optional | Not available | You can write a short description of this adapter. The description will be reflected in the specifications. |
Component variable name | Description | Remarks |
---|---|---|
message_category | Stores the category to which corresponding message code belongs to, when error occurs. |
|
message_code | Stores its corresponding message code of the occurred error. |
|
message_level | Stores the severity of the corresponding message code of the occurred error. |
|
error_type | Stores the error type when error occurs. |
|
error_message | Stores the error message when error occurs. |
|
error_trace | Stores the trace information when error occurs. |
|
Exception name | Cause | Solution |
---|---|---|
InputDataNotFoundException | [Input data] is not specified. | Specify the [Input data] or, draw an input data flow. |
InvalidInputTypeException | [Input data] is not table model type. | Check whether the component specified in [Input data]is table model. |
InvalidPropertyConfigurationException Value is not specified in <property name> |
Value is not specified in [<property name>] | Specify the [<property name>]. |
InvalidPropertyConfigurationException Value is not specified in <property name2> of the row [<row number>] in [<property name1>]. |
Value is not specified in [<property name2>]. | Specify the [<property name2>]. |
InvalidPropertyConfigurationException The value specified in the row [<row number>] of <property name> is duplicated. |
The value specified in [<property name>] is duplicated. | Check whether the value specified for [<property name>] is appropriate. |
ConversionFailedException Column value cannot be processed as specified sort key. |
The contents of input data contains some values that cannot be processed as per the specification in [Sort key configuration]. | Check whether the input data is compatible with the contents specified in [Sort key configuration], or whether any null or empty string is contained. |
ConversionFailedException Date format applicable to [<value of column>] was not found. |
Date format applicable to [<value of column>] was not found. | Check whether [<value of column>] is following the date format of DataSpider Servista. |