Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.

Alteryx Designer Discussions

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

Dynamic Select usage in Alteryx App

dgarmor
7 - Meteor

Dynamic Select appears to only be usable in a standard workflow.  I need the same capability to be able to select the columns of data I want to return dynamically inside my app.   If anyone can offer an alternate solution equivalent to Dynamic Select which I can use in an App I would appreciate any and all solutions.

6 REPLIES 6
AngelosPachis
15 - Aurora

Hi @dgarmor ,

 

Can you please provide an example of the dynamic select tool not working within an app as a reference that we can use?

dgarmor
7 - Meteor

I am trying to use the string from the flow to be used as the formula  for input to the dynamic select but can't seem to get it to connect.  I want to dynamically replace the formula in the dynamic select tool

 

dgarmor_0-1622829176943.png

String F would be the input for the formula replacement.

AngelosPachis
15 - Aurora

@dgarmor Apologies but I'm still struggling to understand the requirements. Maybe you can provide an example of an input, what you want to achieve and an output or share a workflow with mock data if you're concerned about confidentiality

AkimasaKajitani
15 - Aurora

Hi @dgarmor 

 

You can use the Batch macro to rewrite the formula of Dynamic select tool.

 

Macro: This is very simple batch macro. This macro is for general purpose.

The Action tool overwrite the formula of Dynamic select by incoming data from control parameter tool.

 

AkimasaKajitani_0-1622868896974.png

 

This is the sample workflow to use the macro.

 

AkimasaKajitani_1-1622869103235.png

 

 

 

 

dgarmor
7 - Meteor

Thanks  I will give this a try.  I appreciate all the input from the community.

dgarmor
7 - Meteor

This Works.  Thank you so very much.  Took me a couple of tries to solve some issues in my workflow.

Labels