Data (time) slicer

Hi Alteryx Community, looking for a way to slice the input data in "Data slicer example (input output).yxmd" into output data shown in the same yxmd.

I also attached a screen-shot from Excel to illustrate how the slice is done manually

Thanks so much, I really appreciate your suggestion(s)

😀

Data slicer example (input output).yxmd

Data slicer example.JPG

Parse

Date Time

Scheduler

Accepted answers

One way of doing this.

Many thanks

Shanker V

Thanks @binu_acs I learned another use of the Multi-field formula and GenerateRows tools

All comments

One way of doing this.

Many thanks

Shanker V

Step 1: Input

Step 2:

Step 3:

datetimeadd(datetimetoday()+" "+[Temp],[Duration (mins)],"minutes")

Step 4:

datetimetoday()+" "+[RC] < datetimetoday()+" "+[Temp1]

datetimeadd(datetimetoday()+" "+[RC],15,"minutes")

Step 5:

Many thanks

Shanker V

@chrissgtan One way of doing this

Data slicer example (input output).yxmd

Thanks @binu_acs I learned another use of the Multi-field formula and GenerateRows tools

Quick Links

Tags

This months top contributors

Hollingsworth 335