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

[CamodCPA]

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?

Thanks for taking a look!

[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

[CamodCPA]

@MichaelSu 

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?

[CamodCPA]

Found a Workaround with your suggestion!

thank you!

[rafalolbert · Accepted solution]

Hi @CamodCPA,

Example solution is attached:

[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).