Create multiple tables from distinct attribute category values using Model Builder

Question

I've got a shapefile I would like to extract distinct values from an attribute field and have the output as tables based on those values.

The shapefile is made of polygons representing parcels and each parcel is categorized by a "book" value. I can extract a table for each book using the Table Select tool in Model Builder, however, I need to produce a table for each of the dozens of "book" values that make up this shapefile. This is basically a "select by attribute" problem but I will need to sort and produce output in the form of tables. I've attached a pdf of the Layer view and contents to help illustrate the problem.

My question is, what sql expression can I use in the Model Builder Table Select tool that will:

1. Select and sort values based on an attribute field (in this case, by "book")
2. Auto create tables for each category of values (i.e., 200, 209, 235)

I'm open to other model builder tools or methods but the "Table Select" method is the most direct approach, however, I can only create one table at a time - I need to create many in one shot.

Any help is greatly appreciated.

Galindo37

Answer 1

You can use Iterate Feature Selection option to loop through book classes and make a feature layer, from which you can export your table against.

Answer 2

You may want to look into creating a model using iterators. It looks like you can set up the tool to loop through all of the available book ids that you have and then build a model that exports each of those results to a table.

Answer 3

You can use the Split by Attribute tool :)