Dynamic Select usage in Alteryx App

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.

Developer

Developer Tools

Apps

Accepted answers

AkimasaKajitani

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.

DynamicSelectOverwrite_AK.yxzp

All comments

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

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.

DynamicSelectOverwrite_AK.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703