Splice Two Columns of Data ​

Function Description ​

TIP

Concatenate two columns of data using a specified delimiter to form a new column.

Configuration Item Description ​

General ​

Command Input

  • Data Table ObjectTDataTable: You can use the variable returned by the 'Create Data Table' component.

  • Concatenation MethodInteger: Select the concatenation method.

  • First Column to Concatenatestring: Input the name of the first column to concatenate.

  • Second Column to Concatenatestring: Input the name of the second column to concatenate.

  • First Column Number to ConcatenateInteger: Input the number of the first column to concatenate.

  • Second Column Number to ConcatenateInteger: Input the number of the second column to concatenate.

  • Delimiterstring: Input the delimiter used for concatenating the two columns of data. If left empty, the columns will be concatenated directly.

  • New Column Namestring: The name of the new column after concatenation. If left empty, the column name will also be concatenated.

  • Preview in Data TableBoolean: Preview in Data Table

  • Output Variable Value of Print ComponentBoolean: When checked, the variable data or value generated by the component will be output and printed in the console log.

Command Output

  • Concatenated DataTDataTable: Concatenate two columns of data using the specified delimiter to form a new column.

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