Dynamic Select usage in Alteryx App

[dgarmor]

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.

[AngelosPachis]

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]

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

String F would be the input for the formula replacement.

[AngelosPachis]

@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 · Accepted solution]

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.

This is the sample workflow to use the macro.

[dgarmor]

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

[dgarmor]

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