Multiplying multiple columns by multiple columns

Hello community,

I am trying to perform a step using Alteryx Design to multiply 339 columns by their own (A x A / A x B / A x XX / B x A / B x B / etc).

At first, I thought I could use the multi-field formula tool to solve it, but it seems it only allow me to multiply multiple columns by a single one - Am I right? Anyone think in a different way to perform this operation?

Thanks in advance.

Common Use Cases

Best Practices

Accepted answers

patrick_digan

@Yanlk Let me know if the attached works! I think you could transpose, ensuring that you've checked whatever your key column is. Then join the data to itself on your key column, and then use a simple formula to multiply. Hopefully that helps!

multiply columns.yxmd

All comments

FrederikE

@Yanlk,

Yes, the multi field won't solve this. You would have to transpose your data somehow so you get it organized in one field for the multiplication (prob. still use multi field, but just for one part of the multiplikation). Then an IF ELSE Formula should be helpful.

Yanlk

Hi @FrederikE,

Thanks for your answer.

Thought It may have an easier way to do it...I have 400 columns to multiply within, can't imagine doing that by configuring manually . Any other hint?

patrick_digan

multiply columns.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703