List Box to Update Multi-Field Formula Tool

Hi, I'm trying to update a multi-field formula tool from a List Box to select the fields on which I want to apply the UPPERCASE([_Current Field_]) formula. However, I also only want to apply that formula to those fields that are string data type as it doesn't work on numeric fields and causes me to get an error!

I've tried various different methods but unfortunately am coming up at a loss! I'm not sure whether I'm able to change the formula so it only works on string fields or whether I some how need to filter the data out first.

I've attached some screenshots below. Would really appreciate some help!

Pic1.JPG

Pic2.JPG

Pic3.JPG

Preparation

Interface Tools

Chained App

Accepted answers

apathetichell

Multi-Field Formula does not provide you with a way to easily select which fields you want to apply a formula to. The solution to your use case is to use Dynamic Select (actually two Dynamic Selects - one for the fields selected and one for those not-selected) to limit your multi-field formula to selected strings. See the attached for an example of how this works.

dynamic select fields -string.yxwz

All comments

DataNath

Hey @PeterAP - you should be able to use the same fix as here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Macro-gives-error-quot-Unknown-Field-Type-quot/td-p/1009995

i.e. plug your List Box directly into the Q anchor of the Multi-Field Formula tool and select string data type fields only.

PeterAP

Hi @DataNath

Thanks for looking into this for me! Really appreciated.

Unfortunately, I'm not using the ListBox in Select Mode. It's serving another purpose in that it is also updating some unique tools so I think have had to use the Generate Custom List option.

pic4.JPG

apathetichell

dynamic select fields -string.yxwz

PeterAP

@apathetichell - You are a star! Thank you so much!

This definitely put me on the right track. I had to edit the formulae in the "Update Raw XML with Formula" tool to reduce the XML down to the field names alone, but then this worked when I combined it with your solution.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703