Summarized Data with Flag for Aggregated Data

[Mike_at_CG]

Hi All

Hoping to get some help from the community.

I have a raw data file with hundreds of thousands of rows.  I am trying to aggregate the data and the join the aggregated data to another file.

However, for the rows that have been aggregated is it possible to flag that data?  Essentially for the end user can I show them that a single row might have been the combination of multiple rows from the raw data file?

Thank you for any help you can provide.

[ShankerV]

Hi @Mike_at_CG 

Yes, it is possible with the help of summarize tool.

Input was:

Many thanks

Shanker V

[DataNath · Accepted solution]

Hey @Mike_at_CG, after your Summarize tool i.e. the point of aggregation, you can just put a Formula tool where you create your flag like so:

Now any rows that pass through the Summarize will be labelled as Aggregated Data.

Unless you're looking to do this conditionally based on some criteria? If so will need to know a little more!

[FinnCharlton · Accepted solution]

Hi @Mike_at_CG , you can flag aggregations using the 'Count' function of the summarize tool. Counts higher than 1 belong to rows that have been aggregated:

[Mike_at_CG]

Thank you all for the help!