Is it possible to dynamically reference fields in the multi field formula tool

Question

Hi Alteryx Community,

Is it possible to dynamically reference fields in the multi field formula tool?

for example i have two sets of columns, the first set of columns has a set of names and the second set has the same names but has a suffix.

Is it possible to reference these two sets as [_currentField_] and [_currentField_ + suffix] ?

Thank you for any help in advance.

ArtApa · Answer

Hi @stevenD - I don't believe you can do that dynamically in Multifield formula. That's why you need to do something before this tool. You can either try to achieve the desired result with Dynamic Select as it was described, or you can use Transpose, Formula, Cross Tab, or you can add a Select tool and remove Suffix manually.

This will not be dynamic, but will solve the problem.

Treyson · Answer

hello @stevenD

I think that you will have to do something like a dynamic select and then join data back after your multi-field work is done. I don't believe that there is a formulaic way to select the [_currentfield_].

See attached.

Dynamic Select.yxmd