topic Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels) in Geoprocessing Questions

Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

KONPETROV — Thu, 21 May 2015 13:01:06 GMT

Hello, in my problem i have used "sample tool" for a group of points, with the help of an iterator at modelbuilder and with the use of an inline variable. All i want to do is to join my tables with my points but i don't have a common column. So i created a tool to add a column to both of my groups (tables and point f.classes)

So what i did was that. I created two submodels which contain an iterator for tables (the first one) and (the second) an iterator for point fclasses and a connection to my tool which adds a common column to both of them wih the same values 0,1,2,3,4... so as to join them later, and i used an inline variable again for these submodels. My problem is that when i create a new model with these two submodels inside, although i can put their outputs in the boxes "Input table" & "Join Table" , there isn't any column to choose to join them at "Input Join Field" & "Output Join Field".

Please any help would be much appreciated. Thank you very much.

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

ToddBlanchette — Thu, 21 May 2015 13:13:02 GMT

Would it be possible for you to post a screenshot of your model and the parameters you're using?

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

KONPETROV — Fri, 10 Dec 2021 22:03:11 GMT

# Import system modules
import arcpy
import os
from arcpy import env
arcpy.overwriteoutput = True


# Set environment settings
inWorkspace = arcpy.GetParameterAsText(0)
inFC = arcpy.GetParameterAsText(1)
outFC = arcpy.GetParameterAsText(2)
data_type = ""


fieldname = "FID_1"
expression = 'getCalc()'
codeblock = """id = -1
def getCalc():
    global id
    id += 1
    return id"""
expression = 'getCalc()'
# Execute CalculateField
arcpy.CalculateField_management(inFC, fieldname, expression, "PYTHON_9.3", codeblock)


arcpy.Copy_management(inFC, outFC, data_type)

This is the code of the tool i created. Below are the two submodels (at left ) i created and at the right the model i am trying to make. Thank you

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

ToddBlanchette — Thu, 21 May 2015 13:53:28 GMT

1. Is the field 'FID_1' created somewhere else, or already exist?

2. If it does exist, what gets populated when you run the model? If you iterate the same tool over and over, your 'FID_1' will always be equal to 0, because that's what you're passing as an expression every time you run it. The id variable you have doesn't keep counting up every time the model iterates through the tool, it gets reset back to -1 when it's first run.

You're better off iterating through the feature classes and tables using a search cursor within the script itself, and then upping the value in a FOR loop for every feature.

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

ToddBlanchette — Thu, 21 May 2015 13:58:11 GMT

What exactly are you trying to join here anyways? It seems like you're just trying to add incremental values to a feature class and a table. Doesn't your table already have some form of meaningful information that you can use to join to the feature class instead of using a random number?

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

KONPETROV — Thu, 21 May 2015 14:14:57 GMT

what i am doing with my code is that i create a column FID and it gets the values 0,1,2,3,... for all the rows. I don't have any problem with that. It is being done correctly.

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

KONPETROV — Thu, 21 May 2015 14:17:17 GMT

Unfortunately no, that is why i created these columns. My problem is when i am trying to get the group of tables and points from my submodels (outputs) in my model where join tool is. You can see the blank box. There it should be appearred all my fields but... Any suggestion?

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

SepheFox — Thu, 21 May 2015 14:19:55 GMT

Hi Kon, you won't find the field you're looking for in the drop down of the dialog box, because you're using an inline variable, the model doesn't know in advance the exact feature class it is processing. You can just type the name of the field into the dialog.

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

ToddBlanchette — Thu, 21 May 2015 14:28:22 GMT

So if I read you correctly, you have made sure that you have:

1. A feature class that has a field called FID_1 that has unique numbers from 0 -> whatever.

2. A table that has a field called FID_2 that has unique numbers from 0 -> whatever.

and they're not showing up as options on the Join Field tool. What happens when you try to join the outputs from the 2 sub-models to the Join Field tool? Do they populate the parameters for the tool? Are the fields different value types (ie one is a string, one is a int/float)?

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

KONPETROV — Thu, 21 May 2015 14:34:18 GMT

Exactly. They are just not appeared as in the image above. Just a blank box. If i use an iterator for my points i can put it in sort tool and have my field and the same is for my tables. But i cannot have two iterators inside my model, that's why i created two submodels

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

KONPETROV — Thu, 21 May 2015 14:34:59 GMT

REALLY??????? Will it select all fields also? Because i cannot click "Select All"!

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

SepheFox — Thu, 21 May 2015 14:35:48 GMT

What happens when you type in the field names yourself?

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

KONPETROV — Thu, 21 May 2015 14:39:46 GMT

No it cannot be done, just tried it. And i got

ERROR 000622: Failed to execute (JoinField). Parameters are not valid.

ERROR 000732: Input Table: Dataset C:\Win\Sik\Points\fid_%Name%.shp does not exist or is not supported

ERROR 000732: Join Table: Dataset C:\Win\Sik\Tables\f2%Name% does not exist or is not supported

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

ToddBlanchette — Thu, 21 May 2015 15:18:18 GMT

When you try to join the results from your sub-model to the Join Field tool as a parameter, does it not ask you what input parameter you would like to use that for? Ex: join your shapefile output to the Join Field tool, set as parameter and click on Input Table. Do the same for your output table, set as input parameter for the tool, and click on Table to Join.

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

KONPETROV — Thu, 21 May 2015 15:30:20 GMT

I did it that way and as before i first get a message like in the following image i press ok and when i am pressing the button to run, the result is the same as the errors i wrote below

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

SepheFox — Thu, 21 May 2015 15:42:20 GMT

Can you explain what field you are sorting on that puts the two tables into the same order?

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

SepheFox — Thu, 21 May 2015 15:53:19 GMT

I don't understand why you are using iterate feature classes and tables, instead of iterate feature or row selection. Also, do you have overwrite ouptut set to true in the geoprocessing environments?

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

KONPETROV — Thu, 21 May 2015 16:07:22 GMT

i sorted a column in a previous precedure to have my tables in the form i want, it hasn't any infuelnce to what i am doing now. It isn't something so hard but i cannot think what the problem is.

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

KONPETROV — Thu, 21 May 2015 16:11:09 GMT

the overwrite no, how can i do that?

if i use iterate feature or row selection what is the difference? in a model i can have only one iterator, or you mean something for the sub?

Re: Problem with "Join Field" tool in Modelbuilder (iterators & submodels)

SepheFox — Thu, 21 May 2015 16:12:54 GMT

Ok, I'm just not sure that any previous sorting you did will be used in this procedure, for one thing. Since this method clearly isn't working, Todd and I are both looking at the bigger picture of your entire process to see if there is abetter way to get it done, so you don't have to keep hitting your head into the same brick wall.