Splitting range to multiple row

[Ragini1]

Hi All,

I am trying to split the range into multiple rows using the Generate row tool. But it's throwing error as "Value didn't change after loop expression".

Can you please share your ideas as to how to do this?

Field	Value
1-5	a
12-18	b
40-42	c

[BrandonB]

You can take a text to columns to split the Field column into two columns on the hyphen. Then you will want to use the generate rows to create a new column that initializes on the first number, the criteria is that the new column is less than or equal to the second column (larger number), and the increment loop is the new field+1

[Ragini1]

I tried the similar way but still having the issue. First used text to column tool and then generate tool to run the loop.

[atcodedog05]

Hi @Ragini1 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[BrandonB · Accepted solution]

 

[Ragini1 · Accepted solution]

I got it. Thank you.

[messi007]

Hello,

Are you looking for something like this

If not could you please share a the desired output please 🙂

Regards,

[Ragini1]

Thank you. I was looking for this output. 

I got the output using this workflow.

[atcodedog05]

Glad you hear you sorted it out @Ragini1 🙂

Mine was also something similar.

Feel to encourage the other solution authors also for their quick response of help by marking there post also as solution.

Happy to help 🙂

Cheers and Happy Analyzing 😀