Multiply columns

[TomNL]

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!

[JosephSerpis · Accepted solution]

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

[atcodedog05 · Accepted solution]

Hi @TomNL 

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 😀👍

[TomNL]

Thank you very much @JosephSerpis. This works and was not too difficult to implement in my total workflow. I was looking for your first option btw.

[TomNL]

Thanks for your solutioin @atcodedog05. It worked well, but for my personal case i prefered @JosephSerpis 's solution.

[atcodedog05]

Happy to help 🙂 @TomNL 

Cheers and Happy Analysing 😀