Enterprise Designer
Reposition Child Entities in Conditional Router
In the Conditional Router stage's Expression Builder, you can shift a child expression or child group from one parent group to another by dragging the child entity to the desired parent group in the criteria tree on the left.
New Group Statistics Features
Pre-sorted Input Records
In the Group Statistics stage, you can now indicate if the input records are already sorted by checking the box Rows and Columns are pre-sorted in the configured order. When this field is checked, the stage processes the records without sorting them.
Computational Count
When defining the operation to be performed in the Group Statistics
stage, you can choose to display another output column that displays the actual number of
input records processed per group of records. This output column,
ComputationalCount<Operation>Of<InputFieldName>
, is displayed if you
check Get count of records that are computed upon in the
Add Operation window. The count excludes those records that have
null
in the column on which the operation is performed.
Adding Pivot Fields in Output
The process of adding fields in the Fields tab of the Group Statistics
stage options has been simplified. You now just need to add the input values in a grid. Each
of the input values are then appended automatically with the standard stage output columns,
such as <Operation>Of<InputFieldName>
, GroupCount
,
and ComputationalCount
.