Output Table Model Data Log
Operation name
Output Table Model Data Log
Function overview
Writes values of the specified columns from the table model type input data to the execution logs at the selected log level.
Data model
The data model of this component is table model type.
For more details on input/output schema, refer to Schemas.
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 |
|---|---|---|---|---|
|
Output log level |
Required |
Not available |
Select a log level for output of the execution logs.
|
|
|
Column filter |
Optional |
Available |
Enter the filter for columns to output. = Remarks =
For details on filter syntax, refer to Column filter. |
|
Data processing method
|
Item name |
Required/Optional |
Use of variables |
Description |
Remarks |
|---|---|---|---|---|
|
Data processing method |
Required |
Not available |
Select a data processing method.
|
|
Comment
|
Item name |
Required/Optional |
Use of variables |
Description |
Remarks |
|---|---|---|---|---|
|
Comment |
Optional |
Not available |
You can write a short description of this connector. |
|
The syntax available for the column filter is as follows:
|
Filter syntax |
Example |
Description |
|---|---|---|
|
Single |
1 |
When only column number is entered, the column will be output. |
|
On and after |
6- |
When a hyphen is entered after the column number, that column and all columns after that column number will be output. |
|
On and before |
-3 |
When a hyphen is entered before the column number, that column and all columns before that column number will be output. |
|
Range |
2-5 |
When column numbers concatenated with a hyphen are entered, they specify a range, and the columns in the range will be output. |
-
You can specify multiple syntax with commas.
-
Example: 3,4,6-9,12-
-
-
When a column number is repeated, the first one will be effective and latter ones will be ignored.
-
When a column of specified number doesn't exist in the input data, N/A will be output for that column.
Input schema
Same as the schema of input source component.
Output schema
Same as the schema of input source component.
For schema structure, refer to Table model type .
Loading schema in Mapper
The schema needs to be loaded manually.
Specify the schema of the data to be loaded.
For details, refer to Edit Schema.
Mass data processing
Mass data processing is supported.
Parallel Stream Processing
PSP is supported.
For details on PSP, refer to Parallel Stream Processing.
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. |
|