Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Zero-record safe Python Tool

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:

ErrorMessage.png

 

Screenshot 2:

TryExceptBlock.png

6 Comments
sprakasam
Alteryx Alumni (Retired)

Hi Sean, 

 

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

 

-Sonia

EricM
Alteryx
Alteryx

Thanks @SeanAdams!

isubho
6 - Meteoroid

Hi @sprakasam 

 

Is there an update on this defect?

 

Thanks

Subhojit

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes
 
clmc9601
13 - Pulsar
13 - Pulsar
JOTTO
5 - Atom

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