Convert Node

Description

Use the Convert node to change the data type of columns, for example, turning numbers into text.

Option

Columns: Select columns to convert
Data Type: Select data type to convert column into

Tips

If a conversion fails, it means that the current column contains data whose format cannot be converted. Often this happens when otherwise numerical columns contain bits of text like letters or hyphens. You will need to clean these cases before by using the Edit node or [Formula node]().

SQL Equivalent

select CAST({column1} as {data_type}) as column1_newtype ...

↩️ Back to Workflow Settings

Updated on: 05/10/2024