For ease of reference as a solution in future, I have uploaded here my take on the unpivot/pivot method suggested by @Daniel_Weikert , which you can see is faster than the looping solution from my “Matrix Calculator”.
In the meantime, I have updated the component so that you can select the numeric columns that are included in the matrices. It still uses them in the order they appear, but means if you have additional columns (such as SKU) these will be ignored by the calculator. NB, My component doesn’t make use of the unpivot/pivot simply because it would take me a bit more effort to work the required configs for those nodes into a generic component solution.
Matrix Calc using Pivoting.knwf (86.1 KB)
