ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. 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