Change type
Use the Change type tool to change value types, such as a 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.
Input
The Change type tool requires one data input.
Configuration
Use the following configuration options to change your column type.
Go to the Pipes module from the side navigation bar.
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.
In Pipe builder, add your data source.
Click
+Tool.In the search bar, search for Change type. Click Add tool.
Tip
You can also find the Change type tool in the Organize section.
Connect the tool to your data set.
In the configuration pane, under Target columns, select the columns you want to change from your data source.
Under Change to, select the type to change the column to. Choose from Text, Number, Date or Boolean.