topic Re: Model Builder Variable Option: "Insert Values From Tables" Change 50 row limit? in Geoprocessing Questions

Model Builder Variable Option: "Insert Values From Tables" Change 50 row limit?

ErikaCohen — Tue, 20 Jul 2010 14:52:26 GMT

In model builder I'm using the "insert values from table" option to populate my input parameter(list).
The option only inserts the first 50 rows of my table. My table has 504 rows. Is there anywhere I can change how many rows it insert?

Thanks,

Erika

Re: Model Builder Variable Option: "Insert Values From Tables" Change 50 row limit?

EmmanuelBlondel — Tue, 27 Jul 2010 13:25:39 GMT

In model builder I'm using the "insert values from table" option to populate my input parameter(list).
The option only inserts the first 50 rows of my table. My table has 504 rows. Is there anywhere I can change how many rows it insert?

Thanks,

Erika

Sorry for asking you, i am also using the "ïnsert values from a table" option to populate my input parameter, i don't know how inserting more than 50 rows but I would like to know if you know, maybe how automating the "insert values from table" in the model builder? My model is creating a table with a field which contains a list of sql queries, and I would like to get this list in a another input, but automatically...by chance, Do you have any idea? Thanks in advance for your answer

Emmanuel

Re: Model Builder Variable Option: "Insert Values From Tables" Change 50 row limit?

BBicking1 — Wed, 28 Jul 2010 19:27:25 GMT

Sorry for asking you, i am also using the "ïnsert values from a table" option to populate my input parameter, i don't know how inserting more than 50 rows but I would like to know if you know, maybe how automating the "insert values from table" in the model builder? My model is creating a table with a field which contains a list of sql queries, and I would like to get this list in a another input, but automatically...by chance, Do you have any idea? Thanks in advance for your answer

Emmanuel

Hello Erika and Emmanuel,

You can move beyond the 50 entries limit only by manually adding the number of rows you need before you use 'Insert values from table'. The reason this limit is there is because of table validation - it takes long - and working with a large table becomes very wieldy.
In ArcGIS 10 we replaced the series concept with iterators and the Iterate Field Values operator, it takes a table as input, does what you both want to do.

Barbara Bicking
ESRI - Geoprocessing Team

Re: Model Builder Variable Option: "Insert Values From Tables" Change 50 row limit?

TravisPeterson — Sun, 13 May 2012 04:46:08 GMT

Same issue here. I have 9000 records to iterate through-If I only had arcgis 10. I am looking for a way to work around the 50 row limit with VBA...wish I were a better programmer. Is there any advice using VBA.

Re: Model Builder Variable Option: "Insert Values From Tables" Change 50 row limit?

KenNGA — Tue, 12 Apr 2022 18:18:21 GMT

I know this is old, but I'm running the latest version, and this is still an issue. I have the correct amount of rows (130) and it still results in only adding 50. Barbara's answer didn't help explain how to use the iterator in this scenario.

Re: Model Builder Variable Option: "Insert Values From Tables" Change 50 row limit?

KenNGA — Tue, 12 Apr 2022 18:36:00 GMT

For anyone looking for a workaround until we can get an answer, I just had to insert the 50 it allows, then go back to the CSV to remove those 50, save the CSV, then insert the next 50. It's a little better than doing it manually, but still pretty ridiculous.

Ken

topic Re: Model Builder Variable Option: &quot;Insert Values From Tables&quot; Change 50 row limit? in Geoprocessing Questions

Model Builder Variable Option: "Insert Values From Tables" Change 50 row limit?

Re: Model Builder Variable Option: "Insert Values From Tables" Change 50 row limit?

Re: Model Builder Variable Option: "Insert Values From Tables" Change 50 row limit?

Re: Model Builder Variable Option: "Insert Values From Tables" Change 50 row limit?

Re: Model Builder Variable Option: "Insert Values From Tables" Change 50 row limit?

Re: Model Builder Variable Option: "Insert Values From Tables" Change 50 row limit?

topic Re: Model Builder Variable Option: "Insert Values From Tables" Change 50 row limit? in Geoprocessing Questions