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.

DataNath

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!