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

@lca50666 ,

Can you provide sample data ?

and what you want output , can you provide sample ?

1 Like

@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.

1 Like

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

2 Likes

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

@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:

Can you specify which node have you used?

Hey @lca50666,

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

- convert Result Column from String to Number
- Use Math Formula Node to convert the Result Column To absolute numbers

Thanks

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

1 Like