Max value within a range of columns

Hi

 

I have 80 columns in data set.

Trying to find most efficient way to find Max (and then Min) value withing a range of columns.

I want max to be stored in new column.

 

There is lots of missing data so node would need to deal with that as well as string in little of the cases.

 

In excel thats just MAx of a range selected + dragged till the very end of spreadsheed something like 1 minute work.

 

Regards

Dominik

 

P.S, I would rather avoid R Snippet

Hi Dominik,

the Column Aggregator is what you are looking for!

Best, Iris 

1 Like

Iris

I think it helps :)

 

Regards

Nick

1 Like