User guide

Data Integration with Sybase Avaki Studio 163
Projection
 Expression: Click in the column’s Expression field to edit it. This can be any
JavaScript expression, including simple column names from the incoming result
set. Click the “…” button to open the Edit Expression dialog if you need more
room than the table cell provides. You can also right click (either in the table cell
directly, or in the Edit Expression dialog) to show a context-sensitive menu of
column names, variables, and functions that you can paste into the Expression
field. For details on using JavaScript expressions, see “Using expressions within
Avaki Studio” on page 66. For details on the context menu, see “The expressions
menu” on page 71.
 Type: Specify the type of the column. Be sure to specify a type that will match
the result of evaluating the column’s expression.
 Precision: Specify the precision for the column, if applicable for the column’s
type.
 Scale: Specify the scale for the column, if applicable for the column’s type.
Removing duplicates
Select the Generate only distinct (non-duplicate) rows checkbox to eliminate from
the output result set any rows whose data duplicates that of a row already in the output.