Skip to main content

Varicent ELT Help Center

Unique

Abstract

Discover unique rows in either a subset of data or the whole data set.

Finds all unique rows in your data.

When to use this tool

Use when you want to find out how many unique rows are in your data.

How to use this tool

You can either use your entire data set or choose a subset. To use the whole data set, select the Use all columns checkbox. To use a subset of columns, choose the columns from the Columns to include drop down. Any columns that aren't chosen are ignored.

Input

The Unique tool requires one data input.

Configuration

Use the following configuration options to help create your Unique tool configuration.

Configuring the Unique tool

  1. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In Pipe builder, add your data source.

  4. Click symon_add_icon.png +Tool.

  5. In the search bar, search for Unique. Click +Add tool.

    Tip

    You can also find the Unique tool in the Clean section.

  6. Connect the tool to your data set.

  7. In the configuration pane, enter the following information:

    Table 57. Unique tool configuration

    Field

    Description

    Use all columns

    Select if you want to use all columns in your data set to find the unique rows.

    Columns to include

    Select the columns in your data set to find the unique rows. Use this field if you don't choose to use all columns.