Hi all, hope everyone is doing well. I am trying to create aging bucket columns. For example: My Sample input: Customer Document Number Age Company 1A5Company 2 B10Company 3C49Company 4D456Company 5E390Company 6F76 My goal output: CustomerDocument NumberAge 0-30Age 31-365Age 365+Company 1A500Company 2B1000Company 3C0490Company 4D00450Company 5E00390Company 6F0760 Any help is appreciated!

Creating Aging Buckets with a range in each

Hi all, hope everyone is doing well.

I am trying to create aging bucket columns. For example:

My Sample input:

Customer	Document Number	Age
Company 1	A	5
Company 2	B	10
Company 3	C	49
Company 4	D	456
Company 5	E	390
Company 6	F	76

My goal output:

Customer	Document Number	Age 0-30	Age 31-365	Age 365+
Company 1	A	5	0	0
Company 2	B	10	0	0
Company 3	C	0	49	0
Company 4	D	0	0	450
Company 5	E	0	0	390
Company 6	F	0	76	0

Any help is appreciated!

Developer Tools

Accepted answers

Bren_Spill2

Hi @rkeenan125 - see attached workflow

Aging Buckets.yxmd

All comments

Bren_Spill2

Hi @rkeenan125 - see attached workflow

Aging Buckets.yxmd

rkeenan125

Thank you for this!
Would this work if customer showed up multiple times due to have multiple documents and each document has a different age?

apathetichell

if (and only if) you are looking at equal interval or equal records - you can use the delightly pointless multi-field binning tool. @Bren_Spill2 's workflow would have no issues with duplicate lines (assuming you wanted them each counted).

rkeenan125

Thank you both for the help!

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335