Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Need help with bucketizing the rows in an excel data

Dilver_Shaik
7 - Meteor

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

5 REPLIES 5
binuacs
17 - Castor
allwynthomas24
11 - Bolide

Hey @Dilver_Shaik,

 

Please check if the attached solution matches your current requirements.

 

Thanks & Regards,

Allwyn Thomas

 

Spoiler
allwynthomas24_0-1648034751163.png

OllieClarke
14 - Magnetar
14 - Magnetar

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

OllieClarke_0-1648038331015.png

 

Dilver_Shaik
7 - Meteor

Thank You. It helped to solve

Dilver_Shaik
7 - Meteor

Thanks Ollie. It was also nice solution

Labels