Group By - Data360_DQ+ - Latest

Data360 DQ+ Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
Latest
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ Help
Copyright
2024
First publish date
2016
ft:lastEdition
2024-07-09
ft:lastPublication
2024-07-09T15:09:58.774265

The Group By node can be used to group rows by a specified field. If there are duplicate values in the specified field, Group By will group those values into a single row.

Group By is useful when working with rows that contain field values you wish to aggregate.

For example, performing Group By on the Name field in the following sheet:

Name

Salary

Bob

$1,000

Bob

$2,000

Alice

$3,000

Would Group all duplicate Names into a single record, displaying the two records of Bob and Alice in the Group By node's sheet:

Name

Bob

Alice

At the same time, Group By would Group all Salary values for each record into one array per record.

Name

Salary

Bob

[{Salary = $1,000, Salary = $2,000}]

Alice

[{Salary = $3,000}]

These array records will not be displayed in the Group By node's sheet; however, you could add a New Column to the sheet, that uses a function to aggregate these values.

For example, SUM(Salary), which would produce:

Name

Salary

Bob

$3,000

Alice

$3,000