If you can convert the model to a python script, this should be fairly trivial to do, if I'm understanding your needs correctly. It would also work if there's a way to write a custom GP Tool and insert it into a model, but I genuinely can't remember if that's possible, since I really don't use Model Builder.
Some broad strokes/pseudocode:
import pathlib
tbls = [list of your 10 tables]
outFile = pathlib.Path(r'Path\To\Save\Output\Results.txt')
with outFile.open('w') as txt:
# We're essentially producing a tab-separated CSV, so print all of your
# desired headings on this first line. Make sure you don't forget that
# line break \n at the end! Since we're printing everything to a single
# result file, I added a column to the beginning to write which source
# table that row came from
txt.write('Source\tColumn1\tColumn2\t...ColumnN\n')
for tbl in tbls:
with arcpy.da.SearchCursor(tbl, [fields]) as cursor:
for row in cursor:
txt.write(tbl) # Write the table path to the Source column
txt.write('\t'.join(map(str, row))) # Spin out all the column values
# to their respective columns,
# and convert to string on-the-
# fly, so join doesn't crash out.
# NOTE: This assumes all tables have the same columns. If not, this
# gets a little more complex.
txt.write('\n') # Write the newline to move on to the next
# row.
del cursor # They finally fixed the context managers for cursors, so this
# line is obsolete as of (I think) Pro 3.7, and can be
# removed. Keep it for anything older, though.
Another thing you could possibly do (if the schemas are the same between the 10 tables) is to run the Append tool to dogpile all of them into a single table, and then just output that.
If the schemas are different between the 10 tables, it might be helpful to see what we're looking at data-wise to figure out the simplest way to lay it all up at once.
------------------------------
M Reed
"The pessimist may be right oftener than the optimist, but the optimist has more fun, and neither can stop the march of events anyhow." — Lazarus Long, in Time Enough for Love, by Robert A. Heinlein
If this post or another helped you out, please consider giving the post(s) a Kudo or marking them as the Solution. ESRI Staff use both of these features to help keep track of posts on these forums.
