I am really new in Knime and I want to calculate the mean between some columns.
I have a loop on the Excel sheets and in every EXCEL sheet I have a different number of columns:
Sheet1 have 2 columns
Sheet2 have 4 columns
Sheet3 have 7 columns
I need to read the sheet in the loop and than calculate on the columns in the sheet the mean (for every row):
First loop I have
Sheet1 have 2 columns → calculate the mean on 2 columns
The second loop I have:
Sheet2 have 4 columns -->calculate the mean on 4 columns
and so on…
How can I calculate the mean without automatically?
thank you very much for any help!
Have a nice evening for everyone,