List Box to Update Multi-Field Formula Tool

[PeterAP]

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!

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

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. 

[apathetichell · Accepted solution]

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.

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