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)
😀
Solved! Go to Solution.
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
Thanks @ShankerV I learned another use of the DateTime parse and GenerateRows tools
Thanks @binuacs I learned another use of the Multi-field formula and GenerateRows tools