Re-add Missing Columns

[MattR79]

I am running into an issue with columns missing from the output of a Summarize tool due to there being no records for the particular day.  I need to separate records into aging buckets however due to the small size of the age buckets there will often be no records in that bucket.  I need a way to either not lose the buckets in the Summarize tool or to add them back in after the fact.

The buckets are New, 1-3, 4-6, 7-9, 10+

Below is example data.  In the below there are no records in 4-6 which is what I am running into now, but it could just as easily be any of the other buckets with no records.

Users	Aging Bucket
User 1	New
User 1	1-3
User 1	7-9
User 1	10+
User 1	1-3
User 1	7-9
User 2	7-9
User 2	1-3
User 2	10+
User 2	1-3
User 2	7-9
User 2	10+
User 2	1-3

[binuacs · Accepted solution]

@MattR79 One way of doing this

[Qiu]

@MattR79 
Can you provide some sample data before the Summarize tool?
maybe we can do something from there not to lose any bucket.