This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Gather all 9 clues to complete the final Weekly Challenge on Dec 16!
There's a common need to perform the same function on many fields, where you want to bring in data from a secondary field which is defined by the current column name.
So - for example:
So it would be useful to be able to have an indirect function where you can create a string which contains the field you want to use; and then indirect to it.
I had a similar idea here https://community.alteryx.com/t5/Alteryx-Product-Ideas/Add-function-quot-eval-quot/idi-p/42900
Thanks for the suggestion. This is something we have discussed a couple of times but it has not risen to the top of our priorities. Are there other scenarios besides the Field1, Field2, Field3, kind of scenario where something like this, or the idea of an "eval" on a field name would be useful within the formula tools? You talk about this feature in terms of multi-field formula. Is there an application for this in regular formulas?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.