Here is the proposal about an issue that I face frequently at work. Problem Statement - Frequent failure of workflows that have either been scheduled or run manually on server because the excel input file is sometimes open by another user or someone forgot to close the file before going out ...
I have tried one answer suggested in this post using pre and post SQL statement but not worked for me https://community.alteryx.com/t5/Alteryx-Designer-Discussions/identity-insert-don-t-tell-me-this-isn... I am using SQL as source and destination ...
When I'm trying to run SQL Query I received the following error: Error: Input Data (1): Error SQLPrepare: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token <END-OF-STATEMENT> was not valid. Valid tokens: ( NEW FINAL TABLE UNNEST LATE...
Problem Statement - Frequent failure of workflows that have either been scheduled or run manually on server because the excel input file is sometimes open by another user or someone forgot to close the file before going out of office or some other reason. ...