topic Re: Using .dbf file in Model Builder in ModelBuilder Questions

Using .dbf file in Model Builder

JohnMcConalogue — Wed, 11 Apr 2018 08:22:55 GMT

I have imported an Excel file using the "Excel To Table" tool. The file has been converted to a .dbf file.

I want to select the contents of the .dbf file and process these records within Model builder.

Anyone know how to do this?

Re: Using .dbf file in Model Builder

DanPatterson_Retired — Wed, 11 Apr 2018 08:53:50 GMT

Select by Attributes will allow you to select certain records meeting a condition.

Or you can use the whole table as is.

What do you want to do with the table? It sounds like you want to use the table as an input to some task. What is the next step?

Re: Using .dbf file in Model Builder

JohnMcConalogue — Wed, 11 Apr 2018 08:59:06 GMT

I have a field in the table called "Towns". There are a number of records in the table and each record in the table has a value in their "Towns" field. I also have a separate shapefile which contains "town names". I want to be able to select all the records in the Table that has a "Town" value which is also present in the shapefile.

Re: Using .dbf file in Model Builder

DanPatterson_Retired — Wed, 11 Apr 2018 22:12:45 GMT

join the two tables (attribute join), then you can query the combined result