nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Adding a field name and Parsing the filename in model builder

VincentOgodo

I have created a new field name to hold the filename of each table am iterating. I have used the parse path to collect the filename but and preconditioned the the parsing so that the field can be added first before the filename is populated in the new created field. When I run the model I an error that workspace not set for geoprocessor. Any help please?

Vincent

Find more posts tagged with

Accepted answers

All comments

JoeBorgione

Check this out : 000638: Workspace not set for GeoProcessor.—Help | ArcGIS Desktop

And this: https://community.esri.com/thread/48342

I can't quite get through your models logic, but make sure you are accessing a fgdb and not a feature class. A workspace 'holds' the feature or table, so a workspace can be a directory (folder) that has a shapefile or dbf table.

curtvprice

You really don't need the Parse Path step -- Name is already parsed, Name is the name of the table without any file extension. You can simply use Name in your Calculate Field expression -- that is: "%Name%".

VincentOgodo

This did not work. It created the field name but failed to populate the names. It resulted in empty records.

VincentOgodo

I managed to overcome the problem and it works fine. The new problem I have now is how to select part(s) of the file names to be populated in to the new created field. As it is the whole file name is written but I just would like parts of the filename.

DanPatterson_Retired

What is an example of the filename that is being returned?

If it is a string, then there is not tool in arctoolbox to parse text, this can be done via a script or even a field calculator expression parsing the part you want. For example to get the featureclass name from a full path in python you would use

fn <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:/folder/file.gdb/featureclass"</SPAN>

fn<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"/"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="string token">'featureclass'</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

where fn would be your filename

VincentOgodo

Thanks Dan,

Am actually dealing with Tables. The fieldname is a string e.g. et_2003-2004c12 where the last two digits are indicates month of december. 2003-2004 represents the years which I also want to extract out into a separate field. I am a dummy with scripting in python let alone programming strings.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.