Select to view content in your preferred language

How can I export selected records to a new file using Model Builder

5032
12
Jump to solution
10-31-2017 10:36 AM
lindatomaselli
Emerging Contributor

I have a file of all the census blocks in Illinois.  After selecting only the records that I want, how can I export them as a new file in Model Builder?

0 Kudos
12 Replies
lindatomaselli
Emerging Contributor

Dan:

Another “discovery”. While one can set the environment for the fields in the model, the setting is not preserved in the model if it is run again. I found that I must go to Geoprocessing > environments to set it to be constant for all my models that need to preserve the field names. I am sure you knew this, but I am just documenting it “for the record”.

0 Kudos
DanPatterson_Retired
MVP Emeritus

remember that for when you start scripting things... you can set stuff and not rely on colored ovals to assume they are doing the right thing

0 Kudos
lindatomaselli
Emerging Contributor

Yes, I was able to join my local block file to the state block file and select the records that I want. If I remove the join, I can use Copy Rows to save the selected records.

However, in cases where I have joined 2 dbf files and want to export them to another file, the field names are changed, just as in Copy Features. If I interactively use Export, the field names are preserved.

My rhetorical question is, why is there no Export function among the tools?

Thanks for your help again. At least you solved part of my problem.

Dr. Linda Tomaselli, GISRDC

341 Jamaica Way

Niceville, FL 32578

(850) 687-6459 or (850) 897-2012

<mailto:Ltomaselli@GISRDC.com> Ltomaselli@GISRDC.com or <mailto:Ltomaselli@Earthlink.net> Ltomaselli@Earthlink.net

0 Kudos