Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

ranking the slots

AlterCom
8 - Asteroid

Hi, 

 

Having a doubt, 

TimeBucket
2019-08-03 13:11:2310-20
2019-08-03 13:10:0410-20
2019-08-03 13:10:000-10
2019-08-03 13:09:340-10
2019-08-03 13:08:120-10

 

How to divide data in this format?

3 REPLIES 3
estherb47
15 - Aurora
15 - Aurora

Hi @AlterCom 

 

How are you trying to divide the data?

 

If you're trying to divide the bucket into low and high, then a Text to Columns tool will work. Set the tool to parse on the Bucket field, and use a hyphen as the delimiter to separate into 2 columns.

You can rename them with a Select tool.

Let me know if that helps.

 

Cheers!

Esther

NickSm
Alteryx
Alteryx

Hi @AlterCom 

 

My take here is that you're getting a timestamp and looking to bucket the minutes into 0-10, 10-20, 20-30, etc but feel free to add more detail if there's more to it.

 

Can do this with a formula and an If statement.

 

clipboard_image_0.png

 

Quick sample attached

geraldo
13 - Pulsar

Hi

 

Or this formula too

 

 

if DateTimeMinutes([Time]) + (DateTimeSeconds([Time])/100) <= 10 then '00-10'
elseif DateTimeMinutes([Time]) + (DateTimeSeconds([Time])/100) <= 20 then '10-20'
elseif DateTimeMinutes([Time]) + (DateTimeSeconds([Time])/100) <= 30 then '20-30'
elseif DateTimeMinutes([Time]) + (DateTimeSeconds([Time])/100) <= 40 then '30-40'
elseif DateTimeMinutes([Time]) + (DateTimeSeconds([Time])/100) <= 50 then '40-50'
else '50-00'
endif

 

[]

Labels