Mapping Specification Guide

10.5.7
- 10.5.9
- 10.5.8
- 10.5.6
- 10.5
- 10.4.0

Back Next

Adding and Editing a Simple Aggregator

Add a simple aggregator to apply conditions and rules to aggregate data on columns. Edit a simple aggregator to modify the conditions, rules, and group by columns.

From the Actions menu, click

Edit

Aggregator

The

Edit Mapping Specification

wizard appears.

Choose to add or edit an aggregator.

To add an aggregator, click the

New

icon.

To edit an aggregator, click the

Edit

icon.

To add or edit a simple aggregator, click

Simple

On the

Functions

panel, click the

Add Rule

icon and select the

Function

Aggregate Source Name

Aggregate Column Name

, and

Target Column Name

columns.

On the

Conditions

panel, select a column, operator, and enter a value to create a condition.

Click

Optionally, on the

Columns

panel, select the columns you want to group together to perform aggregate calculations on groups of columns.

To select multiple columns press the Shift or Ctrl key and click each column.

Click the arrow icon to add the columns to the

Group by

panel.

Optionally, on the

Data Preview

panel, click

Show

to preview the data that is grouped together based on matching values in the group by columns.

Click

Finish

and then click

Save

Mapping Specification Aggregators

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Mapping Specification Guide

Mapping Specification Guide

Adding and Editing a Simple Aggregator

Adding and Editing a Simple Aggregator