Insert Data ​

Function Description ​

TIP

Insert a row or column of data at a specified position in the data table. If the inserted data is empty, an empty row or column will be inserted.

Configuration Item Description ​

General ​

Command Input

  • Data Table ObjectTDataTable: The variable returned by the 'Create Data Table' component can be used.

  • Insert MethodInteger: Row name, column name refers to the specified header in the data table. Row number, column number refers to the row sequence number and column sequence number in the data table, which is an integer.

  • Insert Row/ColumnInteger: Insert data at the specified row or column

  • Insertion Position Row Namestring: Enter the label of the row where the insertion position is located. The default row name is the first position of each row in the data table.

  • Insertion Position Row NumberInteger: Enter the row sequence number where the insertion position is located. Supports 1 or -1, -n indicates the nth row from the end.

  • Insertion Position Column Namestring: Enter the label of the column where the insertion position is located.

  • Insertion Position Column NumberInteger: Enter the column sequence number where the insertion position is located. Supports 1 or -1, -n indicates the nth column from the end.

  • Insert Data Column Namestring: Enter the column name of the inserted data, which can be empty.

  • Insert TypeInteger: Select the type of data to insert.

  • Content to Insertstring: Insert data in array format, For example, [string1, string2] or [string,'double quotes"',"single quotes'",1,0.01]

  • Preview in Data TableBoolean: Preview in Data Table

  • Print the output variable value of the componentBoolean: After checking, the variable data or value generated by the component during operation will be output and printed to the console log.

Command Output

  • Result after InsertingTDataTable: The data table after inserting data.

Error Handling ​

  • Print Error LogsBoolean: Whether to print error logs to the "Logs" panel when the command fails. Default is checked.

  • Handling MethodInteger:

    • Terminate Process: If the command fails, terminate the process.

    • Ignore Exception and Continue Execution: If the command fails, ignore the exception and continue the process.

    • Retry This Command: If the command fails, retry the command a specified number of times with a specified interval between retries.

Usage Example ​

Process logic description:

Common Errors and Handling ​

None

Frequently Asked Questions ​

None