In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Split DateTime into different columns special

kv-defy
8 - Asteroid

Current Dataset:

 

 

DateTimeIncidents
2022-01-03 00:00:000
2022-01-03 00:30:000
2022-01-03 01:00:002
2022-01-03 01:30:001
2022-01-03 02:00:004
2022-01-03 02:30:005
2022-01-03 03:00:001
2022-01-03 03:30:002
2022-01-03 04:00:000
2022-01-03 04:30:002

 

 

Desired Outcome with a total of 48 periods in a day, 30 minutes interval from 12am to 12am:

 

DateTimeIncidentsPeriodPeriod Number
2022-01-03012am to 12.30am1
2022-01-03012.30am to 1am2
2022-01-0321am to 1.30am3
2022-01-0311.30am to 2am4
2022-01-0342am to 2.30am5
2022-01-0352.30am to 3am6
2022-01-0313am to 3.30am7
2022-01-0323.30am to 4.00am8
2022-01-0304am to 4.30am9
2022-01-0324.30am to 5am10
3 REPLIES 3
Amol_Telore
11 - Bolide

Hey @kv-defy 

 

Here is my solution. Attached is workflow.

 

Amol_Telore_0-1660894254020.png

 

kv-defy
8 - Asteroid

@Amol_Telore thanks Amol.

 

However, for the Period Number, it is not meant to be a Record ID. It is to signify the period in a simpler way (e.g. 00:00AM to 00:30AM) is 1, the highest will be 48. The number will restart to 1 when it is a new time period (e.g. 00:00AM to 00:30AM).

Amol_Telore
11 - Bolide

Hey @kv-defy 

 

I have modified the workflow. PFA.

Labels
Top Solution Authors