Mapping Specification Guide

10.4.0
- 10.5

Back Next

Adding and Editing an Advanced Aggregator

Add an advanced aggregator to apply conditions and expressions to aggregate data on columns. Edit an advanced aggregator to modify the conditions, expressions, 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 an advanced editor, click

Advanced

On the

Functions and Conditions

panel, click the

Add Condition

icon.

Select a target column name.

On the

Functions

tab, select a function, click the arrow icon, and select a column to add the function to the Expression editor.

Optionally, on the

Rules

tab, select a column and datatype and click the arrow icon to add the rule column to the Expression editor.

Optionally, on the

Lookup

tab, select a column and datatype and click the arrow icon to add the Lookup column to the Expression editor.

Click

and then 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 an Advanced Aggregator

Adding and Editing an Advanced Aggregator