Joining Python Scripts outputs by using ModelBuilder

Question

Hi everyone, I am new in python and have just started to write some simple scripts similar to the following one: # Import arcpy module import arcpy, os, sys #Parameters L= arcpy.GetParameterAsText(0) O= arcpy.GetParameterAsText(1) O_4= arcpy.GetParameterAsText(2) #Variables O_4= O #Select by location arcpy.SelectLayerByLocation_management(O, "WITHIN", L,"", "NEW_SELECTION", "") #Select by Attribute arcpy.SelectLayerByAttribute_management(O_4, "SWITCH_SELECTION", "") #calculate field arcpy.CalculateField_management(O, "Feild2", '"Warning"', "VB") #calculate field arcpy.CalculateField_management(O_4, "Field2", '"ERROR"', "VB") When I attempt to join those scripts outputs (by using "Join" tool) in ModelBuilder; I get this error: <> I have also set my parameters as following: Display Name Data Type Type Direction L Feature Layer Required input O Feature Layer Required input O_4 Table Required output Do you have any solution for that?

FereshtehAghyan · Answer

Rebecca,

As you, Darren and Wes suggested, I will replace all "O_4" with "O", I will also make feature layers from my source files, hopefully these suggestion solve the issue.

Since I am new in python I prefer to use ModelBuilder for doing "iterate" and "join" tasks. I have similar scripts to this one (about 20 scripts) which select some records in attribute table and their output are supposed to be join together In ModelBuilder.

FereshtehAghyan · Answer

Yes that is a whole script. In this script, some features are supposed to be selected by "select by attribute" and select by location" then their two attribute table fields are supposed to be populated by"warning" and "error" values.  I will implant this and some other scripts (about 20-30) with similar functions in a model builder and the model builder  will join output of all those scripts.

RebeccaStrauch__GISP · Answer

Fereshteh,

I have several suggestions and comments.  First, I agree with Darren and Wes that you do not need to ask for both "O" and "O_4" if they we be set the the same value right away.  Just ask for "0" and then include you next line if needed, but it may help to have more code (see my tips below).

Q: Since it looks like you are wanting to write it in arcpy/python, is there a reason you are trying to get this to work in ModelBuilder too?  Personally, when I was first learning arcpy and it's syntax, I created a couple ModelBuilder tasks and then converted to python and then fixed the code the way I needed.  But that was not an efficient way for me, since there was so much "noise" I had to fix (but that was with ArcGIS 9.x, so may be better now).

With that said, when using python to select, you typically need to make it into a feature layer first.  See Select Layer By Location—Help | ArcGIS for Desktop  for more explanation.

Tips for future posts.

- when posting code, look thru Posting Code blocks in the new GeoNet​

- It takes a while to figure out the geonet structure, but  GeoNet Community Structure​  might help, and if needed you can move your post with Moving Content to the Geoprocessing​   or Model Builder​  or Python​  spaces to get a more focused set of responses.

- with me mentioning the other places with the @ and the location, that will automatically show a reference in those spaces.  That is the way to include other places without having to post it twice. (not that you did htat, but good to remember).