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
@mcoleman12
Have you try using Replace formula to remove it?
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.