CSV Remove Duplicates

<< Click to Display Table of Contents >>

Navigation:  Actions > CSV Data >

CSV Remove Duplicates

This action removes duplicate rows that contain the same data.

 

General

CSVRemoveDuplicates1

 

Case sensitive

Enable this checkbox for case-sensitive comparison.

 

Save number of deleted rows to variable

You can save the number of deleted rows to a variable if needed. This field can be left empty.

 

Duplicate removal mode

Complete match - the default option. Only rows that are exact duplicates are removed.

Match on specific columns - rows that are duplicates only in the specified columns are removed. You need to list the column numbers separated by commas for control. Column numbers start from 1. If you leave the field with numbers empty, the action will check the entire row (complete match). The action will ignore incorrect column numbers.

 

Source and Source format

Source and Source format tabs are identical for most SCV actions. Read description in "CSV Get Data Information" chapter

 

 

note Related Topics

CSV Open Data

CSV Get Data Information

CSV Add Column

CSV Remove Column

CSV Sort by Column

CSV Move Column

CSV Read Cells

CSV Write Cells

CSV Merge Data

CSV Filter Data

CSV Data Loop

CSV Remove Duplicates

CSV Save Data

SQL Query to CSV File

Read system events to CSV

Load process info to CSV

 

 

Note: This feature is available for Business license only