antonio6vieira Posted March 8, 2015 Share 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 Link to comment Share on other sites More sharing options...
g1h2j3 Posted March 8, 2015 Share 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. Link to comment Share on other sites More sharing options...
willem Posted March 8, 2015 Share Posted March 8, 2015 Number of rows: TableName.AvailableRowCount Link to comment Share on other sites More sharing options...
antonio6vieira Posted March 8, 2015 Author Share 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... Link to comment Share on other sites More sharing options...
antonio6vieira Posted March 8, 2015 Author Share 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. Link to comment Share on other sites More sharing options...
willem Posted March 9, 2015 Share 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... Link to comment Share on other sites More sharing options...
antonio6vieira Posted March 9, 2015 Author Share Posted March 9, 2015 The data is given by a company. I suppose I can't just tell them that..... Link to comment Share on other sites More sharing options...
Recommended Posts