Iteration

[Raj008]

Hi, I am new to Alteryx. I have a workflow in which I am doing iteration for a value to either floor or round when the value is not zero. If the value of a field becomes zero, I do not want to do the iteration; if the value is not zero, I am want to do the iteration. Can anyone help me to resolve this. Thanks in advance. 

[echuong1]

Can you expand what you mean by "iteration?" Do you have some sample data that you can share?

A before and after would be helpful.

[Raj008]

Hi...

I am working on a payment schedule and the final payment balance usually comes a value less than 0, so I used iteration to bring the value closer to 0. In one instance, the value becomes zero and still the iteration continues and the schedule outputs NULL values. So, when the value reaches 0, I need to stop the workflow and when the value is not 0, I need the iteration to continue.

Thanks

[echuong1]

Are you able to include a copy of your workflow? This will better help us troubleshoot/find a solution.

[Qiu · Accepted solution]

@Raj008 
Maybe I am wrong, but would a sinple filter tool will seperate 0 from others?

Assign RecordID to all your records, then filter out zero  and do your iteration for non-zeros, but bring all the proceed data back tother with the assigned RecordID.
As @echuong1 suggested, a before and after would help us to be further assistance.

[Raj_Singh1]

Spoiler

Spoiler

Hi Raj!

i have attached a solution, hope it solves your problem. please let me know if you have any questions, if you provide me dummy dataset i can configure the solution to match your dataset.

[Raj008]

Hi Qiu,

You are right, a simple filter helped me to get through the issue. Thanks a lot for all of your suggestions....

[Qiu]

@Raj008 

Thank you for the mark!