Is there a Knime-node which is able to calculate the entries in a row of a table??/

for example I count my filed with value counter then how can I to calculate the probability of them???

pleas let me know

Thank you

Is there a Knime-node which is able to calculate the entries in a row of a table??/

for example I count my filed with value counter then how can I to calculate the probability of them???

pleas let me know

Thank you

If you use the Value Counter node to count how many times each entry or value occurs (frequency), you can use a simple Math Formula node to calculate their relative frequency (note that probability is formally something different). You can use the formula:

$count$/COL_SUM($count$)

Cheers,

Marco.

thanks a lot for your reply. it helps me a lot

I resolve it with Javasnippt node

but I think that this is so better.

Hi mah,

you can also use the groupby node. Group on your first column and use any column in the aggregation tab and select Percent.

Best, Iris