Data (time) slicer

[chrissgtan]

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)

😀

[ShankerV · Accepted solution]

Hi @chrissgtan 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @chrissgtan 

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

[binuacs]

@chrissgtan One way of doing this

[chrissgtan]

Thanks @ShankerV I learned another use of the DateTime parse and GenerateRows tools

[chrissgtan · Accepted solution]

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