Use column header as number within formula

[TomNL]

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.

[atcodedog05]

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.

[atcodedog05 · Accepted solution]

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

[TomNL]

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.

[atcodedog05]

Happy to help 🙂

Cheers and Happy Analyzing 😀