row by row multiplication problem

[lca50666]

I want to compare the average data in table1 with a new derived field in table2, which is calculated by subtracting 3 times the Sigma value (Avg - 3xSigma). None of the currently used methods can achieve this.

Initially, I used Table Transposer to transpose the data, aiming to apply a mathematical formula to the transposed fields. However, since the field type became “?” after transposition, it was impossible to perform calculations.

Is there a better way to compute values between columns?
Thank you.

table1:

table2:

If anyone knows I’d be really grateful as this has stuck with me for a long time

[tqAkshay95]

@lca50666 ,

Can you provide sample data ?

and what you want output , can you provide sample ?

[lca50666]

@tqAkshay95 Hello,
table.xlsx (11.8 KB)
I combined the two tables into one file. I hope that the output table will only have the calculated row (1_Avg_-3Sigma) and the original rule data can be removed.

[yogesh_nawale]

Hello @lca50666,

Check the below solution

Output

WorkFlow Attached
RowByRowMultiplication.knwf (96.5 KB)

Files
1.xlsx (9.3 KB)
2.xlsx (9.3 KB)

Regards,
Yogesh

[lca50666]

@yogesh_nawale Thank you! This method is truly amazing! I have learned so much.

[lca50666]

@yogesh_nawale Hello, I’ve encountered another problem. When changing the calculation from ‘-’ to ‘+’, its type changes, and it can’t be converted to double… The picture is below:

[yogesh_nawale]

Can you specify which node have you used?

[yogesh_nawale]

Hey @lca50666,

To convert “-” to"+" i.e Absolute values you can

1. convert Result Column from String to Number
2. Use Math Formula Node to convert the Result Column To absolute numbers

Thanks

[lca50666]

thank you!I later used Column Auto Type Cast String to Number node to solve this problem