I would like to return the column that contains the lowest number in a specific row. How can i do that preferentially using the code editor inside the assign label?
You can do this with a single for loop in the Value field of the Assign Labels activity:
- Table table = Table("GlobalTable1");
- int row = 1;
- int smallestColumn = 1;
- double smallestNumber = table[row][1];
- for (int i = 2; i <= table.numCols; i++) {
- double curNumber = table[row][i];
- if (curNumber < smallestNumber) {
- smallestNumber = curNumber;
- smallestColumn = i;
- }
- }
- return smallestColumn;
13 People are following this question.
