Adding a Calculated Column in Data Table Editor

Create new columns based on calculations using data from existing columns in your data table.

In all cases, this new column is calculated for every row in the data set.

 

  1. On the Calculated Columns pane, click New Column > Calculated.

     

    The Numeric Calculated Column pane displays.

  2. Fill in the Title field.
  3. Select one of the following Usage options:
    • General – Evaluates calculated columns last in the pipeline after transforms, joins, etc. This is the default setting.
    • Join Key – Calculation is evaluated directly after loading the source data, making it available for use such as a Join Key when creating a Join table.
    NOTE:
    • The Usage setting is not available for Query-on-Demand enabled data sources, such as JDBC or Kdb+. It is also not available for Join Tables.
    • This feature is only available for Data Library data tables.
  4. Select the Set Type Manually checkbox. The Type drop-down list box is enabled.
  5. Select either:
    • Numeric

      The most common type of calculation allows creation of new numeric columns.

    • Text

      Allows new text columns to be created based on input string manipulation. 

      When Text is selected, Custom Sort Order is enabled.

    NOTE: Other types of calculations include:

  6. Set the designed display Format (for example 0.0 %).
  7. For the Text calculated column type, you can opt to enter the order of the values (separated by a comma) in the Custom Sort Order field.
  8. To add or build an expression, you can manually enter it in the Expression box or click .

    Build an expression by double-clicking in the list of available Functions and Columns.

    NOTE: You can also use parameters in the expression.

    You can also click on a function then .

    To search for a particular column or function, enter it in the Search Columns/Search Functions box.

    Or enter one or more characters/alphabets into the Search Columns box and the suggested list of columns that matched the entries will be displayed.

    For example, after entering 1, the list will be displayed such as below:

  9. Click   to validate the formula.
  10. Click  to save the expression and close the dialog.
  11. Click  . The new calculated column is added and displayed in the Data Preview.

 

 

(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support