Generate rows in a loop

Question

Hi

I have a question on generating rows in a loop.i to generate time sequence for a fixed start and time time. The tricky part is I need to generate the same set for different sets(a,b,c) by inserting the set name as a new column everytime on generating the timstamp.

To make it clear,the order is

1) Generate timestamp with 10 min interval

2)Add a column by name "Sets" and add string "a" against the generated time stamp.

3)Generate the same timestamp sequence below the existing one and add the string "b" against the new timestamp

I hope I have made the question clear and this can be done in alteryx.

MarqueeCrew · Accepted Answer

@Newbie_1,

You won't be a newbie long if you keep up this type of work in Alteryx.  I've solved for this challenge using an input text file.  In the configuration of the input file I start with the beginning time, the interval, the interval count and units (e.g. minutes) as well as the desire count of sets.  We generate one row per interval count and then compute a timestamp for each interval.  This data is then multipled in another generate rows process where we create a row for each set.  Next we sort the data and rename the set number into a set name (another text configuration file).

The workflow is attached for your review.

Cheers,

Mark