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