Zero-record safe Python Tool

[SeanAdams]

The Alteryx Python tool currently throws an error if the inbound record set has zero rows (screenshot 1).

In order to manage that - you need to create try-except block around the Alteryx.read that instead creates an empty record set data frame. (screenshot 2).   This is inefficient because every time you change the canvas before the python tool, you need to re-code a static field list into the try-except block (i.e. you can no-longer deal with variable fields)

Please could you change the Alteryx.read method to create a zero-record dataframe with the correct column names if the input is zero-length?

Thank you

Sean

Screenshot 1:

Screenshot 2:

[sprakasam]

Hi Sean, 

We've logged it as a defect and have it our backlog. We'll update you when it's done

-Sonia

[EricM]

Thanks @SeanAdams!

[isubho]

Hi @sprakasam 

Is there an update on this defect?

Thanks

Subhojit

[clmc9601]

Here's another post about this: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Stop-ERROR-when-0-records-are-read-into-PYTH...

[JOTTO]

Hi everyone. A workaround is to use a try, except block in your python code.