Optimize column transformation

Dear all,

 

I am struggling to transform my data into the right format for using a t-test (2ind. samples). I am able to do it but I need like 10 nodes.

 

My data looks like this:

 

identifier a1 a2 a3 b1 b2 b3
pet 0.38 0.62 0.28 0.52 0.83 0.67
pet2 0.78 0.26 0.43 0.02 0.5 0.1
pet3 0.7 0.44 0.84 0.16 0.02 1

 

Goal: t-test should be performed between (a1,a2,a3) vs. (b1,b2,b3) for each pet.

Does anyone have an idea to minimize the number of nodes to achieve this? (cannot use any other node apart from the ones that come with KNIME, e.g. switching to R is not possible).

 

Thanks in advance!

Hi kamsen,

can you also add how the result of the transformation should look like?

Thanks! Iris