We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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