Hi all,
I have some columns named with a number (1, 2, 3, ...). Can I refer to the column name/number in a formula? An "easy" example would be something like [_CurrentField_]+[_CurrentField_]. So for column 1 it should result in 2, for column 2 it should result in 4.
Thanks.
Solved! Go to Solution.
Hi @TomNL
Yes you can. Answer is same
You can use Multi Field formula tool. Refer the link below.
https://help.alteryx.com/current/designer/multi-field-formula-tool.
Hope this helps 🙂
I will modify the workflow for you.
Hi @TomNL ,
Here is the modified workflow
Input:
Output:
Add columns -
Overwrite-
By changing these options:
Workflow :
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind😀👍
Here is a interactive lesson on the tool.
https://community.alteryx.com/t5/Interactive-Lessons/Multi-Field-Formulas/ta-p/424422
Hi atcodedog05,
This helps a lot. As I needed the column number in all cells below, I use CurrentFieldname now, together wilt tonumber.
tonumber([_CurrentFieldname_])+tonumber([_CurrentFieldname_])
Thanks a lot.
Happy to help 🙂
Cheers and Happy Analyzing 😀