Transformation Calculator Enhancements
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.
Procedure: How to Change the Display of Columns and Variables in a Calculator
open a calculator, click the Insert or Compute button,
or select the WHERE or HAVING Filter
from the SQL Object context menu.
tab defaults to the tree view. To change it:
the Name heading bar, as shown in the following
The columns and variables are now shown in a list,
as shown in the following image.
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.
you display additional columns. The available columns are: Format,
Description, and Category.
SQL Conversion Notes. Indicates
if the function can be translated to SQL.