Tools to classify/Group/Bin values

[richg]

Hi Community people,

Is there an easier way to set the below if statement up. Not sure the bin tool is the right one.

Being the great tool alteryx is I am expecting to find a tool that allows you to 

 > Select the column you want bucketed/binned

 > Set the parameters for the intervals

> Set how many intervals you want

IF [Total Rev] = 0 THEN "0" 
ELSEIF [Total Rev] <= 10 THEN "0-10"
elseif [Total Rev] <= 20 then "10-20"
elseif [Total Rev] <= 30 then "20-30"
elseif [Total Rev] <= 40 then "30-40"
elseif [Total Rev] <= 50 then "40-50"
elseif [Total Rev] <= 60 then "50-60"
elseif [Total Rev] <= 70 then "60-70"
elseif [Total Rev] <= 80 then "70-80"
elseif [Total Rev] <= 90 then "80-90"
elseif [Total Rev] <= 100 then "90-100"
elseif [Total Rev] <= 110 then "100-110"
elseif [Total Rev] <= 120 then "110-120"
elseif [Total Rev] <= 130 then "120-130"
elseif [Total Rev] <= 140 then "130-140"
elseif [Total Rev] <= 150 then "140-150"
elseif [Total Rev] <= 160 then "150-160"
elseif [Total Rev] <= 170 then "160-170"
elseif [Total Rev] <= 180 then "170-180"
elseif [Total Rev] <= 190 then "180-190"
elseif [Total Rev] <= 200 then "190-200"
elseif [Total Rev] <= 210 then "200-210"
elseif [Total Rev] <= 250 then "210-250"
elseif [Total Rev] <= 300 then "250-300"
elseif [Total Rev] <= 400 then "300-400"
elseif [Total Rev] <= 500 then "400-500"
elseif [Total Rev] <= 750 then "500-750"
elseif [Total Rev] <= 1000 then "750-1000"
ELSE "more than 1000" ENDIF

[scottj]

I would use the tile tool.  In the attached example, i created all the bins and matched to the data run through a Tile tool set to manual.  I even used a generate rows to create most of the manual typing for me.

[scottj · Accepted solution]

Just noticed I was offset by one.  Here is the fixed version.

[Claje]

Another way to do this which adds some more configuration options is to use Generate Rows and a Join tool to cover all of your Revenue cases.

I've attached a quick example using the same test data that @scottj used, with one row added for the >1000 category.

Note that this option will work really well for small numbers as in this example, but that from a performance perspective other options may be faster if we need to have multiple categories in the millions or hundreds of millions.

[richg]

Thanks for your solution. I found the way you used the binning tool really insightful.