Skip to main content

Varicent ELT Help Center

Record ID

Abstract

Add a unique numeric value to each row in your data set.

Add a unique numeric value to each row in your data set. You can use this if you don't have a unique way to identify rows in your dataset.

Input and output

You need an existing data set in your pipe to use this tool.

When you export the data, it assigns a numeric value to every row in your dataset starting from 0. This column is added as the last column in the dataset.

Configuration

Use the following configuration options to configure the Record ID tool.

Configuring the Record ID 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 the Pipe builder, add at least one data source to your pipe. For more information on adding a data source, see the Data tool.

  4. Click symon_add_icon.png + Tool.

    The Tools modal opens where you can add tools, such as the Aggregate tool to your pipe.

  5. In the Tools modal, search for Record ID and then click + Add Tool.

  6. In the configuration pane, enter the name of the new column in the Column name field.

    The new column appends to the beginning of your dataset.

Usage example

Let's say you have data with no unique identifiers, and you want to track adjustments made to the transactions. You want to add unique identifiers to your dataset.

To add unique identifiers to your dataset, you want to add the Record ID tool and name it Unique ID to your pipe. The tool adds a unique ID to identify adjustments made to the transactions. Now, you can see which data has had adjustments.