Need help with bucketizing the rows in an excel data

[Dilver_Shaik]

Hi Team, I have a data in my excel for about 500 records. My requirement is I have to bucketize those based on percentage and serial number given in the excel from 1-500.

For Example :

       50% of records i.e, 1-250 fall under category 'Category1'

     Next 25% of records i.e., 250 - 375 should fall under category 'Category2'

And the last 25% of records i.e., 375 - 500 should fall under category 'Category3'

Could you please help me how to achieve this in Alteryx?

Your time and effort is appreciated.

Thanks

Dilver

[binuacs · Accepted solution]

@Dilver_Shaik 

[allwynthomas24]

Hey @Dilver_Shaik,

Please check if the attached solution matches your current requirements.

Thanks & Regards,

Allwyn Thomas

Spoiler

---

[OllieClarke · Accepted solution]

@Dilver_Shaik here's a simplification of @binuacs' method:

[Dilver_Shaik]

Thank You. It helped to solve

[Dilver_Shaik]

Thanks Ollie. It was also nice solution