In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Generate rows, value did not change after the loop expression

fangyi189
8 - Asteroid

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!

13 REPLIES 13
Prakash_A
5 - Atom

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?

Michal
9 - Comet

The end date likely has some null values. If you replace the null values in End Date with today's date (DateTimeToday) or some date in the future, it will work.

Satoshi2
5 - Atom

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.

rogerfed2603
5 - Atom

Hi all,

 

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!

 

rogerfed2603_0-1676565645758.png

 

Labels
Top Solution Authors