topic Re: join field tool with overwrites in Python Questions

join field tool with overwrites

CameronCole1 — Wed, 13 Jul 2016 15:33:44 GMT

I am using model builder to join the excel table I have with a parcel layer based on an ID field. However, every time I update my excel file and re-run the tool the data doesn't overwrite what was already in the parcel table. it just adds all of the fields to it again.

Do I need to pull it out to python and add an overwrite function or is there a easy tool I can just drag into model builder to overwrite what is in the table. Please give a little insight of what is my best practice

Re: join field tool with overwrites

DanPatterson_Retired — Wed, 13 Jul 2016 17:50:15 GMT

remove the old join and rejoin the new. Given that you are updating this all the time, it is pointless to make the join permanent except for backup purposes... but who needs a model for that

Re: join field tool with overwrites

CameronCole1 — Wed, 13 Jul 2016 20:16:26 GMT

So I do the join of the table and the feature class and it works. When I right click and look to remove join there is no join relationship there. Same goes for the using the remove join tool. It doesn't see a join.

How can that be? The field are being joined based off one field and I see the new fields in the attribute table.

Everything you have said I tried before you told me. I must just be missing a step.

I am taking the New input parcel (ParcelGDB) making it a parameter to define it then saying remove the join making (ParcelGDB(4)) then adding the new join to add the excel data based off of a field creating (ParcelGDB(3))

Re: join field tool with overwrites

DanPatterson_Retired — Wed, 13 Jul 2016 20:31:57 GMT

other than the mention of making layers when using remove join in modelbuilder Remove Join—Data Management toolbox | ArcGIS for Desktop

Re: join field tool with overwrites

AbdullahAnter — Wed, 13 Jul 2016 21:16:03 GMT

Dan, How do Cameron Cole can update excel file without remove join?!!

If Cameron Cole can update his excel file, he should be removed join before.

so I don't think the Remove Join is the problem of this issue.

thanks

Re: join field tool with overwrites

CameronCole1 — Wed, 13 Jul 2016 21:29:20 GMT

Abdullah,

I made a few changes and actually got it to work. This is the new model I made to make it work. I need the Remove Join so the parcel table didn't have the same info joined to it every time I joined the new excel file.

Re: join field tool with overwrites

AbdullahAnter — Thu, 14 Jul 2016 18:39:48 GMT

Cameron,How do you can update excel file without remove join?!!

Why do you need to put Remove Join so?

Re: join field tool with overwrites

CameronCole1 — Fri, 15 Jul 2016 15:04:47 GMT

Abdullah, so if I don't remove the join my parcel layer will still be looking at my old excel table for the information and will still have the joined data associated with it. Once I remove the join my parcels will be back to just there original information. then from there I can rejoin the parcels to new information as it come up.

Re: join field tool with overwrites

AbdullahAnter — Sat, 16 Jul 2016 11:17:36 GMT

That is not the correct answer.

Because excel will not allow you to update the file if the file still joined in arc map.

so I wonder that you think that Remove Join is the solution for your thread.

Re: join field tool with overwrites

DanPatterson_Retired — Sat, 16 Jul 2016 11:40:11 GMT

You would get an error if the join wasn't removed, ... you remove the join, update the information and it can be rejoined with new information when the need arises.

Re: join field tool with overwrites

AbdullahAnter — Sat, 16 Jul 2016 15:04:43 GMT

yes,Dan. you are right.

so Cameron will not need to put Remove Join in his model.

because if there is update for table it is mean removed join before.

Re: join field tool with overwrites

CameronCole1 — Mon, 18 Jul 2016 14:58:49 GMT

AWESOME!! I am right now creating scale models to then work the full data set. working out the kinks now is great!

Thanks so much for all the feed back and brain storming. I hate being the only GIS person in the office so I cant brain storm with people that know what I am going though!