Repeat sequence for rows based on another variable

[Grisham312]

I’m trying to find the best way to sequence a set input and then in order on repeat give a specific output. Similar to the fill down repeating series in excel when you double click on a cell.

I have 2 types Y and N.  For Y it can be B2, B4, B5, B6, B7, B8, B9 and for N it can be A1, A2, A3, A4.  I need them to be repeated/looped. 

Below is an example of my data.

Below is my desired output.

Below is the input I want repeated based on whether the data is Y or N.

Please let me know if you have any suggestion or tips for me!  

Thank you!

[wdavis · Accepted solution]

Hi @Grisham312 

I have built a workflow that I think matches what you are looking to achieve.

Using a Multi-Row Formula I am giving a group for each of your 'Types' with numbers up to how many different 'Spots' you have.

To achieve these I also added in a new field in the bottom text input which is 'Group'.

Let me know if this works for you or if you have any questions.

Thanks

Will

[Jonathan-Sherman]

Hi @Grisham312,

I believe this is what you're trying to achieve? Also my workflow is fully dynamic to allow the "generating rows" to be changed without need for the formulas to be adjusted as @wdavis does.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[JulioMO]

Hi @Grisham312 ,

Attached you will find a simple workflow that gets the job done!

Let me know if it works for you. 

Regards!

[Peggy]

I am wondering about the initial input.  The tool looks like "Text Input Tool".  Why use this tool vs regular input?  I used "Input" with a .json file.  But when I do that, these examples don't work - although I can see the data from the input.  .  How do I input the json file as "Text Input"?  The contents will be different every time.  This is not a static input file.