Data360 Analyze

Hi everyone
The issue: in the new Agg node, use the "counted value" to apply a filter inside the node using an advanced script? (it was possible in BRe by the value of groupCount )
The attached files will be more explicit:
- Agg1: normal use, I add a new field "list of colors" ... it works well
- Agg2: same as Agg1 but I would like to add a filter on the result (directly inside this node) -
- Agg3: same as Agg2 but with a local counter to apply a filter to the number of occurrences
In AGG2 and AGG3, "color_count" is always equal to "1"
Is it possible to directly use the value "color_count" while keeping the correct value?

Attached files

AGG Test 2507.lna

The Aggregate node provides a built-in 'joinStrings()' aggregation function. See the integrated Help or the documentation for the latest version of the produce more details.

You can filter the aggregation output records by configuring the Aggregate node's ImplicitWriteMode property  to Never write records.

Then in the ProcessRecords script explicitly write the records that match your criteria.

Here is the updated data flow [Requires v.3.4.x or higher]

Attached files

Aggregation_Node--Using_the _Built-in_Aggregate_Functions_3.4.2--share - 29 Jul 2019.lna

Great! A small tricks but a great help for BRE to D360 migration!
Thak you Adrian