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

[KONPETROV]

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.

[ToddBlanchette]

I think Sephe Fox​ and I are both a little fuzzy on what exactly you're trying to accomplish... it seems like you're trying to do so much to fix one little problem.  Is there any chance you'd be willing to share your shapefile and table with us so that we could take a look at it?  As long as it's not sensitive data or anything like that.

[KONPETROV]

of course

[SepheFox]

Well, the difference is that the model will iterate through rows of your feature class or table, instead of datasets in a folder or geodatabase. The overwrite can be set here:

[KONPETROV]

oh i will try it, i also attached the shp and table

[ToddBlanchette · Accepted solution]

So I noticed that the XY data in your table are exactly the same spatial location as the points shapefile you gave me.  If this is what you're trying to achieve, it's pretty easy:

1. Create XY events from your table (I used the spatial reference [projection] that your point shapefile was using)

2. Export the XY events to a shapefile, and you will have a points shapefile that has all the information that was included with the original table.

You should now have a properly projected shapefile with all the data you wanted in it in the first place.

[SepheFox]

Haha!

[KONPETROV]

oh my god!! maybe i should have become a fireman or a doctor or just something else than working with gis.

Thank you both very much for your time.

[SepheFox]

Don't feel bad! It takes a long time to get to know the intricacies of ArcGIS. It's not as simple as say, being a doctor.