LogoLogo
About
Tables: v2
  • Home
  • Guides
  • BDK
  • REST API
  • Release Notes
Tables: v2
  • Getting Started
    • Tables Overview
  • Table Creation
    • Create a Table
    • Create a Sample Table
    • Create a Pivot Table
    • Create an Integer Table
    • Create a Table from JSON
    • Create a Combined Table
    • Get a Table from a File
  • Rows
    • Get Rows
    • Get Row Count
    • Get Row Number
    • Get Value from Row
    • Insert a Row
    • Insert an Empty Row
    • Remove Duplicate Rows
    • Set a Row to JSON
  • Columns
    • Get a Column
    • Get a Column's Values
    • Get a Column Number
    • Get Column Count
    • Get Column Stats
    • Get Column Names
    • Change a Column's Data Type
    • Delete Columns
    • Insert a Column
    • Move a Column
    • Rename a Column
    • Rename Columns
    • Round a Column's Values
    • Update a Column
  • Cells
    • Set a Cell in a Table
  • Conversions
    • Convert CSV to a Table
    • Convert a Table to CSV
    • Convert a Table to Excel
  • Manipulations
    • Clear a Table
    • Combine Tables
    • Copy a Table
    • Extract a Subtable
    • Query a Table
    • Sort a Table
    • Replace a Value
    • Replace a Value in a Column
    • Transpose a Table
Powered by GitBook
On this page
  • Overview
  • Input Concepts
  • Output Concepts
  • Examples

Was this helpful?

Export as PDF
  1. Rows

Remove Duplicate Rows

Deletes duplicate rows from the table, optionally based on specified columns.

Overview

This procedure removes duplicate rows from a table. If no columns are specified, all columns are considered when identifying duplicates. This automation procedure is useful for cleaning up data and removing redundancy.

Input Concepts

Concept
Type
Description
Default
Required

table

table

The table from which duplicate rows should be deleted.

No default

Yes

uniqueness columns

list of strings

Column names to consider for identifying duplicates.

All columns are used by default.

No

Output Concepts

Concept
Description

table

The updated table with duplicate rows removed.

Examples

1. Removing Duplicates - Default Behavior

By default, all columns are considered when removing duplicates.

create a sample table
remove the duplicates from the table

2. Removing Duplicates by Specifying Columns to Consider

create a sample table
remove the duplicates from the sample table where
    the uniqueness columns are "name", "age"

Last updated 21 days ago

Was this helpful?