Mean

Hi! I have a table with 46.460 rows and 241 columns.

I have to do the mean of each row. Anyone knows how can i do this?

If i transpose and make a column mean with group by, the computer can't do it.

Just use GROUP BY node

You can look here how to do it:

https://www.youtube.com/watch?v=JQ-OWMt48ew

 

Fabio, thanks for your response. But the ideia is to average the rows and not the columns. Can i do this on group by?

Just use Transpose before GroupBy, then Transpose again.

Yet another solution: Unpivot, GroupBy (include previous row identifier as a group-by column), then Pivot again.

The Column Aggregator node, is the "transposed oposite of the groupby" :-) 

Thanks a lot Geo and Iris!! Column Aggregator node is the best!!