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
Top Solution Authors