Skip to main content

Varicent ELT Help Center

Merge columns

Abstract

Checks for text in the columns specified in sequence, returns the first set of text it finds, replacing the original columns.

Checks for text in the columns specified in sequence, and returns the first set of text it finds, replacing the original columns.

When to use this tool

Use when you have inconsistent text columns and want to combine them into a single column.

Input

The Merge columns tool requires one data input.

Configuration

Use the following configuration options to help create your Merge columns configuration.

Configuring the Merge columns tool
  1. In , add your data source.

  2. Click symon_add_icon.png +Add Tool.

  3. Click See all tools.

  4. In the search bar, search for Merge columns. Click Add tool.

    Tip

    You can also find the Merge columns tool in the Calculate section.

  5. Connect the tool to your data set.

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

    Table 44. Merge column tool configuration

    Field

    Description

    Column

    Select the column or columns that you want to use to merge.

    New column name

    Enter the new column name.