Skip to main content

Varicent ELT Help Center

Change type

Abstract

Change column type for specified columns to text, number, date, or boolean.

Change column type for specified columns to text, number, date, or boolean.

You can change the column type for multiple columns. Each column will be changed to the same new type.

When to use this tool

Use when you want to change value types.

Input

The Change type tool requires one data input.

Configuration

Use the following configuration options to change your column type.

Configuring the Change type

  1. In , add your data source.

  2. Click symon_add_icon.png +Tool.

  3. In the search bar, search for Change type. Click Add tool.

    Tip

    You can also find the Change type tool in the Organize section.

  4. Connect the tool to your data set.

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

    Table 60. Change type tool configuration

    Field

    Description

    Target columns

    Select the target columns from your data source.

    Change to

    Select they type to change the column to. Choose from Text, Number, Date or Boolean.