In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Post SQL running before data is uploaded

byarsmc79
7 - Meteor

I have a workflow that inputs data into a table and then runs some post-sql scripts that runs an update query based on the data that was just loaded into the table.  The problem is that the post-sql script appears to be running before the data is loaded and therefore the new data is not in the update.

 

byarsmc79_0-1648476775213.png

 

It is also concerning that the pre-sql runs before the workflow has processed the data.  This has caused issues where the "Drop table" pre-sql runs and just to have an up-line tool error and leave the table dropped.  

 

This happens both on my desktop(2020.3.5) and on the server.  Are these bugs in the pre/post sql process? 

0 REPLIES 0
Labels
Top Solution Authors