Official |[Table] Switch Row/Column

Operation name

Switch Row/Column

Function overview

Switches the rows and the column of the input data.

Data model

The data model of this component is table model type.

= Remarks =

For more details on input/output schema, refer to Table model type .

Properties

= Remarks =

For details on use of variables, refer to Variables.

Required settings

Item name	Required/Optional	Use of variables	Description	Remarks
Name	Required	Not available	Enter a name to use on the script canvas.
Input data	Required	Not available	Select a component on the script canvas.

Comment

Item name	Required/Optional	Use of variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this connector.

Mass data processing

Mass data processing isn't supported.

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 shown below. 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

The input data can only be specified in table model type.
All data is handled as string.

All of the input data is converted into strings, the switching operation is performed, and the results are output as strings.

Exception messages

Exception name	Cause	Solution
InputDataNotFoundException	Input data isn't specified.	Specify Input data or draw a data flow.
InvalidInputTypeException	Input data isn't table model type.	Check whether the component specified in Input data is table model type.