Skip to content

Keep Duplicate Rows

Function Description

TIP

This function will return a new data table, determine whether there are duplicate elements in the specified column, and return the row where the element is located

Configuration Item Description

General

Command Input

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

  • Select TypeInteger: Select column name or column number

  • Column namestring: When the selected column data is consistent, it is retained. Single column input [column name], multi column input [column name 1, column name 2, column name 3]

  • Column numberstring: When the selected column data is consistent, it is retained. Single column input [1], multi column input [1,2,3]

  • Keep WayInteger: Select retention method

  • Preview in Data TableBoolean: Preview in Data Table

  • Print Component Output Variable ValueBoolean: When checked, the variable data or value generated by the component will be output and printed to the console output log.

Command Output

  • Duplicate lines TableTDataTable: Data table returned after retention

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