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 |
Solved! Go to Solution.
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
I tried the similar way but still having the issue. First used text to column tool and then generate tool to run the loop.
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 😀👍
I got it. Thank you.
Thank you. I was looking for this output.
I got the output using this workflow.
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 😀