Free Trial

Alteryx Designer Desktop Discussions

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

Dynamic Input injecting 'select * from' before actual sql query

mcoleman12
5 - Atom

I'm using a Dynamic Input tool inside a standard Macro. Intention of this is to allow users to input connection string to server to then run some sql. 
macro user input takes connection string, db schema, table name. 
those inputs are put together and passed as a field going into the dynamic input tool, at which the tool is configured to 'Change Entire Path' with the incoming field that has been updated with the connection|||query. 
This was working in prior version (2021) and now failing on 2023.2.  
The problem is that the dynamic tool is inserting a 'select * from' by default before the actual query. so then the query fails because it doesn't end up being a real query when executed. 
its getting added *here   connection|||*query 

2 REPLIES 2
OTrieger
12 - Quasar

@mcoleman12 
Have you try using Replace formula to remove it?

apathetichell
19 - Altair

Any chance something else changed (like the string the Action tool is looking for or the location of a file) - Alteryx is pretty loathe to change core features (like Dynamic Input) unless they are addressing critical bugs - and this would point to an underlying code change. It's possible it was part of a hardening for AMP usage - but most of the time we see drastic differences between versions it's on a python/connector tool - not something from core designer.

Labels
Top Solution Authors