recreating vlookup in alteryx

Hi Alteryx,

I am trying to recreate this vlookup I did in excel in alteryx, but I am stuck. I was able to create the age column, but now I am stuck on creating the bucket column. thanks to everyone that helps in advance!

I tried to do

if [Age]<=30
then 0-30
else
if [Age]<=60
then 31-60
else
if [Age]<=90
then 61-30
else
if [Age]>90
then 90+
endif

but it just made it angry

vlookup.PNG

vlookup alteryx.PNG

Datasets

Reporting

Tips and Tricks

Best Practices

Accepted answers

Luke_C

Interesting, works fine for me. Can you confirm the age field is numeric? You should also make this new field for bucket a string rather than numeric

All comments

Luke_C

Hi @wave_wstn

You could tweak your if statement to this and it should work. You need to put your buckets in quotes and also just use 'elseif' rather than 'else if'

if [Age] > 90 then "90+"
elseif [Age]<=90 and [Age]>=61 then "61-90"
elseif [Age]<=90 and [Age]>=61 then "31-60"
else "0-30"
endif

wave_wstn

I tried to do what you said, but for some reason it still gets angry. I even tried it without the endif to keep the colors from changing, but it still wouldn't run. Is there a specific reason for that or are there just too many arguments?

@Luke_C

bucket.PNG

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703