community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Include Row which breaks condition in Generate Rows tool.

When working on the Weekly Challenge #108, I was trying to design a non-macro solution.

 

I ended up settling on the Generate Rows tool and was trying to find a way to generate rows until I had reached or exceeded the maximum density, however, I ran into an issue where I'd always have one too few rows, since the final row I was looking for was the one that broke the condition I specified.

 

In order to get around this, I came up with the following solution:

 

Spoiler

 

Idea_IncludeConditionBreak_GenerateRowsTool.PNG

Idea_IncludeConditionBreak_GenerateRowsTool.PNG

 

Essentially, I just set my condition to twice that of the true threshold I was looking for. This worked because I was always doubling the current value in my Loop Expression, and so anything which broke the 'actual' condition I was looking for ([MaxDensity]), would necessarily also break the second condition if doubled again.

 

However, for many other loop expressions, this sort of solution would not work.

 

My idea is to include a checkbox which, when selected, would also generate the final row which broke the specified condition.

 

By adding such a checkbox, it would allow users to continue using the Generate Rows tool as they already do, but reduce the amount of condition engineering that users are required to do in order to get that one extra row they're looking for, and reduce the number of  potentially unseen errors in their workflows.