antonio6vieira Posted March 8, 2015 Posted March 8, 2015 Hi! Is there an immediate way to get the row number of a table without looping through all the rows? Thanks
g1h2j3 Posted March 8, 2015 Posted March 8, 2015 You want the number of rows in your table or the specific value in a row? If the specific value use that expressions: TableName[RowNumber].ColumnName or TableName[RowNumber, ColumnNumber] Number of rows, i don't know.
antonio6vieira Posted March 8, 2015 Author Posted March 8, 2015 Actually I meant the row corresponding to the value. Let's say i have a table and i want to search for a value. I want to know on which row that value is...
antonio6vieira Posted March 8, 2015 Author Posted March 8, 2015 The reason for this is that I have a process that loops through a table with hundreds of lines (roughly 500 lines but depends on input - could be thousands) and for each line has to search a value on table that also has hundreds of lines. So for each row of the first table i am looping through the second, which ends with Simio warning me concerning something about excessive loops... So, I thought of a workaround that consists on immediately getting the row value of the value and thus I wouldn't need to loop the second table. Any ideas on how to do this or any other workaround suggestions? Please I need to solve this today... Thanks.
willem Posted March 9, 2015 Posted March 9, 2015 Hi, The only suggestion that i have given the limited understanding is to introduce another criteria to narrow down the amount of row that are found. In essence, manage the data better...
antonio6vieira Posted March 9, 2015 Author Posted March 9, 2015 The data is given by a company. I suppose I can't just tell them that.....
Recommended Posts