Alteryx designer Discussions

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

Is there any way to pass a constant into an interface tool?

Highlighted
ACE Emeritus
ACE Emeritus

I have a process I'm building out right now that is going to accept user input.  This user input will be a drop-down with data derived from a SQL query.  However, the query to get that data uses an "ID" field as a filter, and I am also in the process of migrating to a new "ID".  Is there any way to configure this so that it will be dynamic inside of these interface tools, or will I have to update this query manually once this transition has occurred?

I have tried using a User Constant and it seems that since these are evaluated at runtime, it won't function for a drop down, but I wasn't sure if anyone in the Community had any more luck.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @Claje,

 

I'm not entirely sure what you are trying to achieve, of course when I first read this I immediately thought of the workflow constants but you have mentioned this isn't sufficient.

 

Would it be possible to visually show what your desired output is?

 

Ben

Labels