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:
- Select and sort values based on an attribute field (in this case, by "book")
- 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.