Iteration

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.

Developer Tools

Accepted answers

Qiu

@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.

All comments

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

Qiu

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

Raj_Singh1

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.

Payment Macro.yxmc

Raj008

Hi Qiu,

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703