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.