Multiply columns

Hi,

In attached workflow I need to multiply columns:

[1] * [Souce_1], [2] * [Source_2], etc and show the results in new columns [New_1], [New_2], etc

The thing is that I need to do this for about 950 columns, so I really am looking for an "easy" solution here.

I think I need the Multi-Field Formula tool, but I stuck at this point.

Hope someone can help me out here with a worked example.

Thanks!

Workflow

Join

Preparation

Accepted answers

Hi @TomNL I mocked up a workflow wasn't completely clear on your desired output so please see my workflow

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍