Hi all,
I'm facing this error where "The value did not change after the loop expression. Do you mind taking a look at my configuration?
Thank you!
Hey @fangyi189,
You're missing an "s" in the DateTimeAdd formula...it should be:
DateTimeAdd([Date_Starting],1,'days')
Still the same problem
I used the same generate rows tool on a sample data, it worked. However, when I used it on my own data, it doesn't. Is there any possible reason why? It's in date format already.
Hi, I kind of solved the problem already. Thanks for the help! (:
Error: The value did not change after the Loop Expression.
*Note: I have given correct expression as mention ur solution but am still getting same error msg
please tell me anything else needs to be Checked?
I think this error will occur if it contains data that does not affect the expression(causes an eternal loop), or if there are null.
How to check I think： The next data after the last data "Generate rows" was able to generate contains the error factor.
Struggling with a similar issue. In the below table, there are missing months (May 2020 and May 2021). I want to generate rows for these months, and i want to use the "value" from the previous month for this new row.
Would be grateful for someone to help!
Thanks!
