Custom Binning in Alteryx

Hi all,

I am trying to figure out how to bin values in alteryx using custom range. I have an "age" field and some how i want to group them in bins of:

- 0 to 17

- 18 to 29

- 30 to 69

- 70 to 79

- 80 +

Is there any way i can bin these and give this a new field name i.e " Age Group".

I have tried using the multiple binning tool but it dose't allow me to specify values.

Thanks,

Aqil

Topic of Interest

Accepted answers

JohnJPS

Hi @AQILKURJI,

A formula tool can do this: new field "AgeGroup" with:

IF [Age] <= 17 THEN
  "Group1"
ELSEIF [AGE] <= 29 THEN
  "Group2"
ELSEIF [AGE] <= 69 THEN
  "Group3"
ELSEIF [AGE] <= 79 THEN
  "Group4"
ELSE
  "Group5"
ENDIF

... where the values are whatever you want, whatever field type you want.

Hope that helps!

John

All comments

JohnJPS

Hi @AQILKURJI,

A formula tool can do this: new field "AgeGroup" with:

IF [Age] <= 17 THEN
  "Group1"
ELSEIF [AGE] <= 29 THEN
  "Group2"
ELSEIF [AGE] <= 69 THEN
  "Group3"
ELSEIF [AGE] <= 79 THEN
  "Group4"
ELSE
  "Group5"
ENDIF

... where the values are whatever you want, whatever field type you want.

Hope that helps!

John

AQILKURJI

Thanks John !

lcm3k

Hi there,

I tried something similar but receive an error (Invalid type in operator) when I complete the IF statement. Do you know why that would be the case and how I can fix?

IF [Spend] >= 75000 THEN 'Large Spend'
ELSEIF [Spend] < 75000 AND [Spend] >= 10000 THEN 'Medium Spend'
ELSE 'Small Spend'
ENDIF

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335