arcgis-10.2arcgis-desktopmodelbuildernaming conventions
Every quarter I will be replacing the two CSV files at the beginning of the model. I would like the final Excel file and feature class to each have a name that reflects the input CSV file name (please see model below). For the example below, I would like to have them renamed as: 2015Q1, as a reflection of the names of the input CSV files.
Is this possible to do?
I am not using 'iteration', which most of the similar questions are referring to.
Without seeing your model it seems odd that your precondition is failing. I knocked a model together (see image below) and it worked fine. When the attribute query created a selection it was copied out when nothing was selected the export was skipped. It makes me wonder if you are using the correct select tool?
You can do this using the Calculate Value tool to modify the "Name" string variable to replace spaces with underscores. When you are saving the Spatial Join feature class output, you can then use inline variable substitution:
C:\gisworkspace\WORKSPACE\testing_workspace\%output_value%.shp
....where 'output_value' is the output name from the Calculate value tool.
Here is what the parameters of the Calculate Value could look like:
Expression:
ReplaceName('%StringInput%')
....where 'StringInput' is the name of your 'Name' model parameter
Code Block:
def ReplaceName(name) :
return name.replace(" ", "_")
Data type:
String
Here is a quick example in ModelBuilder:
Best Answer
I would recommend the Parse Path tool in ModelBuilder. Make sure to select the "Name" parse type. In this (very simplified) model, I included a "workspace" variable that I can call at any point and combine with the name value from the parse path output. The syntax for that would be
%Workspace%\%Value%in the output path parameter. You should also attach a precondition so that the parse path tool is in sync with the rest of the model.