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;
@Matthew Gillespie This was exactly what i needed! Thank you so much!
13 People are following this question.
