Executing an Iterative Function in Python

I am trying to pass parameter to, and execute, a function within the Python tool. It is actually a function within a function. this is a specialized IRR calculation (it differs from the built in Alteryx IRR calculation). The code was "converted" from a VB custom Excel function (works fine there)

What I don't know is how to properly execute the function. Seems like Alteryx makes an attempt before erroring out

A simplified version is attached

Becker_IRR_4.yxmd

Python

Accepted answers

philipmannering

Hey @aaronindm ,

See the Python code for multiple rows attached.

python tool troubleshooting 2.yxmd

All comments

philipmannering

HI @aaronindm,

I'd be lying if I said that I understand what you're doing. But I have got it to run without error. The issue, I think, is that data is read in and out of Atleryx as Pandas DataFrames, therefore you need to a few extra steps to extract the data from the DataFrame before you can use it in your function.

Take a look at the attached.

python tool troubleshooting.yxmd

aaronindm

@PhilipMannering Thanks you for the reply but I am not seeing the additional code you added, can you call that out specifically for me? The Python tool code from the one I uploaded looks to be the same as the one you uploaded.

There is likely some nuance that I am missing

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703