Data Type Conversion Transformations: Convert Column Types

The data type of a column determines how you can query that column’s data. For example, you can filter and group by a text or date column, or perform math calculations on a number column. Sometimes, fields are tagged incorrectly. If needed, use the column-type conversion transformations to convert columns to the correct types.

• Text to Date Transformation: Convert the Column Type
  A date column is sometimes tagged as text if it contains unexpected string values or dates in different formats. To use date functionality, such as grouping by month, use the Text To Date transformation to change the Text column type to Date.
• Text to Number Transformation: Convert the Column Type
  To perform a mathematical calculation on the column, such as calculating the average, use the Text To Number transformation to change the Text column type to Number. You can perform mathematical calculations on numeric columns only. Numeric types include the percent data type.
• Number to Text Transformation: Convert the Column Type
  To group and filter by a numeric column, use the Number To Text transformation. You can group and filter by text columns only.