List box to update the Select function on a Multi Formula Tool (In Macro) Not working

Hello Hello Hello!

Might be the Friday blues, or I am approaching this all wrong. But, in general, I have a multifield formula tool inside of a macro, I want to set up a List box to select what fields get passed through. I have been at this for some time today now. Hopefully, someone can point me the right direction on setting up this interface!

Below is a simple version just a visual of how I set up the interface to function with the multi-formula tool in the macro (not the actual thing). Am I thinking somewhere in the settings?

multi form.PNG

Thanks for taking a look!

Macros

Interface Tools

Accepted answers

MichaelSu

Select_Columns.yxzp

rafalolbert

Hi @CamodCPA,

Example solution is attached:

workflow.yxmc

All comments

MichaelSu

Hi @CamodCPA ,

If you're looking to simply select which columns you would like to pass through, just use a select tool instead with the same exact config. The trick is to deselect all of your columns in the select tool, otherwise by default they will get passed through even though you only selected specific columns within the analytic app.

Thanks,

Mike

Thank you for the fast reply and the example for selecting columns!

So, This I have tried--however the goal is to maintain the input data structure and only apply the multi-field formula to selected fields!

Can the select window in this tool be manipulated through interface tools?

Thanks again!

rafalolbert

Hi @CamodCPA,

Here is one way to do this:

- first, please have a look at list.csv output, this gives you the format of how List Box selections look like (comma delimited list in double quotes) - try single and multiple selections to see the difference

- for each field you'll need to get a separate Action tool and target value is the '@selected-value' property for the respective field name

- first, please select 'All Types of' in the Multi-Row Formula tool to expose all field and tick 'Selected or Unknown Fields'option - only when a specific field is un-ticked, its '@selected-value' property becomes visible for Action tool (when ticked this is not visible)

- finally, pretty much all settings/metadata of any tool including Multi-Row Formula are exposed for the Action tool, with this specific tool being quite advanced and very powerful at the same time, i suggest you play with it to understand the way it works, for example you may want to create copies or overwrite the original fields etc.

Thanks,

Rafal

#Excuse me, do you speak Alteryx?

workflow.yxmc

rafalolbert

Hi @CamodCPA,

Example solution is attached:

workflow.yxmc

CamodCPA

@rafalolbert ,

Wow,

Wonderfull explanation!!! I ended up creating a workaround. but this is fantastic. I Love how you approaching teaching this by outputting the list csv!

Thank you so much!

gwiz

@CamodCPA recognize it has been a few years on this but I am experiencing a similar issue. Curious what your workaround was. I want to pass through all the columns and only apply the multi-field formula to selected fields via a macro. However it is by default just applying the multi field formula to all fields configured in the macro (i.e. it is not updating the fields I select from a list box).

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703