Transformation Calculator Enhancements

How to:

When viewing the Functions grid in the Transformation, Filter, and SQL calculators, there is a new column named Category that shows the folder name for each function.

Top of page

Procedure: How to Change the Display of Columns and Variables in a Calculator

To open a calculator, click the Insert Insert button or Compute Insert button button, or select the WHERE or HAVING Filter from the SQL Object context menu.

The Columns/Variables tab defaults to the tree view. To change it:

  1. Right-click the Name heading bar, as shown in the following image.

    Name heading options

  2. Select List View.

    The columns and variables are now shown in a list, as shown in the following image.

  3. Optionally, you can right-click the Name header and select the following options:
    • Sort Ascending or Sort Descending. This option is only available while in List View.
    • Best Fit. Resizes the column to fit its data.
    • Customize. Lets you display additional columns. The available columns are: Format, Description, and Category.
    • SQL Conversion Notes. Indicates if the function can be translated to SQL.