jit.cellblock : How to get the maximum value of a column?
Hello,
i have a jit.cellblock and i want to scan it column by column and get the maximum value and it's position.
How can i do that?
I attached an example. To load the text file to the jit.cellblock press the "read" message and select the attached txt file.
Thank you.
jit.dimop is one way to do this.
Hello,
Sorry i didn't understand how it works.
Can you tell me more about it because "help" wasn't very helpful.
Thank you.
jit.dimop applies an operator across a specified dimension of the input matrix. In this case the @step attribute is the one to look at. I'm using a single step in the x dimension, and 3 step in the y dimension. The operator is "max" - so in effect I'm saying: give me the maximum in each column, with the column's specified height at 3 cells.
Make sense?
You can adjust this to the height of your columns as needed.
Hello,
Sorry i didn't explain which part i didn't understood. I understood these things but i have two questions.
1) Do i have to do both filling and checking for max value (because i thing you do those together) or i can fill the table and then check for max?
2) The titles i have between the values of a column are a problem? (check the image i attached)
Sorry for not been clear from the beginning.
Thank you!
Yes, the format you've used here would be problematic if you're trying to use jit.dimop to calculate the max value.
Is there a reason you're not using a spreadsheet for this?
Ok.
What do you mean? Is there any other spreadsheed object to do that or you meanto use another program like excel for example?
There is no other spreadsheet object in Max. I was referring to another program like Excel.
Ok can i extract data from jit.cellblock so that ecxel can read them?