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 ...
Updated on: 05/10/2024
Thank you!