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