Skip to main content

Adding Calculated Columns to Datasets for Simple Data Transformations

Calculated columns are a way to add simple data transformations to a dataset. After a calculated column is added to a dataset, it can be used as the basis of an attribute, just like any other dataset column.

  • Calculated Column FAQs This section answers the most frequently asked questions (FAQs) about creating and using calculated columns.
  • AtScale Internal Data Types This table lists the AtScale internal data types and the corresponding external SQL data types, which are supported by the data warehouses that work with AtScale.
  • Add a Calculated Column to a Dataset You can add a calculated column to any dataset that you have imported into a project. Calculated columns are retained in the project library even when you remove the dataset from the Canvas.
  • Troubleshoot Invalid Calculated Columns When you add a calculated column to a dataset, AtScale tests the validity of the formula. If the formula is invalid, you must fix it and retest before saving. This section describes the most common causes of invalid formulas.
  • Extract Values from a Map Although AtScale does not support the MAP data type, you can create calculated columns from strings containing maps.