Use column header as number within formula

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.

Use_Currentfield_in_formula.yxmd

Developer

Help

Accepted answers

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

Use_Currentfield_in_formula.yxmd

All comments

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.

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

Use_Currentfield_in_formula.yxmd

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.

Quick Links

Tags

This months top contributors

Hollingsworth 335