Delete Duplicate Rows ​

Function Description ​

TIP

Delete duplicate row data from the specified column or the entire table of the data table object.

Configuration Item Description ​

General ​

Command Input

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

  • Deletion MethodInteger: Deletion Method

  • Specified Column Namestring: When all selected column data are identical, they will be deleted. For a single column, enter [Column Name]. For multiple columns, enter [Column Name 1,Column Name 2,Column Name 3]

  • Specified Column Numberstring: When all selected column data are identical, they will be deleted. For a single column, enter [1]. For multiple columns, enter [1,2,3]

  • Deletion ModeInteger: When duplicate rows are detected, you can choose to keep the first row, keep the last row, or delete all.

  • Preview in Data TableBoolean: Preview in Data Table

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

Command Output

  • Data After DeletionTDataTable: Used to store the data table after deleting duplicates.

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