VERIFIED SOLUTION i
X

How to count records being processed through a Spectrum dataflow

UPDATED: September 12, 2017


Spectrum creates GroupCount and GroupID fields when using the Group Statistics stage. The GroupCount field allows you to view how many records pass to a specific stage.

You can also use a Transformer stage to add an integer field with the value 1 populated.  Using a Group Statistics stage, you will be able to sum up the values in the new integer field to determine how many records made it to a stage in total.

Environment Details

Product affected: Spectrum™ Technology Platform
Version: 9 SP3, 10 SP1, 11 SP1, 12
Operating System: Windows, Unix, Linux

Downloads

  • No Downloads