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

Error outputs on tools

Right now - if a tool generates an error - there is nothing productive that you can do with the error rows, these are just sent to the error log and depending on your settings the entire canvas will fail.

 

Could we change this in the Designer to work more like SSIS - where almost every tool has an error output, so that you can send the good rows one way, and the error rows the other way, and then continue processing?    The error rows can be sent to an error table or workflow or data-quality service; and the good rows can be sent onwards.   Because you have access to the error rows, you can also do run stats of "successful rows vs. unsuccessful"

 

This would make a big difference in the velocity of developing a canvas or prepping data.

 

Can take some screenshots if that helps?

2 Comments
myastarling
10 - Fireball

This would be immensely useful for me. I currently have a workflow that is gleaning information from Excel files. The only problem is that sometimes people in other departments are opening these files and leaving them open overnight (grrr....). So what I end up with in the error log is the pathname and the error message that 'the process cannot access the file because it is being used by another process (32)'

 

What I would love to do is retrieve a log of the errors and from that glean the pathname and flag this as one of those that needs to be re-run. As it stands right now, it is a manual process that I need to tend to daily.

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes