Adding Column in a Excel sheet whoes input has n no of Column

[TajuddinTaji]

I am trying to put a formula where I need to multiply 1 column value which is fixed to other column value, here the input no of column (other column) keeps on changing.

[atcodedog05]

Hi @TajuddinTaji 

You can use a multi-field formula tool for this.

Workflow:

Resource link : https://community.alteryx.com/t5/Interactive-Lessons/Multi-Field-Formulas/ta-p/424422 

Hope this helps : )

[Kenda · Accepted solution]

Hi @TajuddinTaji 

The key here will be the Multi-Field Formula tool!

Use an expression like the following to update each Col field: 

[Value]*[_CurrentField_]

[TajuddinTaji]

Super thanks, it works