In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Should be easy - dynamic input for a set list of field results

MCDR929
8 - Asteroid

Not quite sure why this is giving me such fits, but it is, so here I am.
I have a data input that contains a list of account numbers.  I'm attempting to use a dynamic input for a very large database, to only pull the data from the list of account numbers contained in the input. 
So, I'd imagine I'm adding a modify SQL query to replace specific string, but something isn't working, and the dynamic input tool is erroring out (despite testing the connection itself). 
Does anyone have any sample workflows available for this type of scenario? I'm sure it's some sort of issue in either my query itself or the modification entered into the dynamic input tool.

 

Thanks!

1 REPLY 1
AngelosPachis
16 - Nebula

Hi @MCDR929 ,

 

If you open up the provided example for the Dynamic Input tool (right-click on the tool > Open example), examples #2 and #3 seem to be representative of the problem you're facing.

 

AngelosPachis_0-1639762571482.png

 

They update a string within a SQL statement and maybe you can do the same with yours?

 

Labels
Top Solution Authors