Hi folks, I’ve been trying to automate a process in Model Builder, but it refuses to work and I don’t understand why. I’m trying to make a join based on attribute data and then use calculate field to populate a field in the original layer, but it’s just not working. Although the join claims to have worked, I cannot access the joined fields, and so cannot complete the process. The weird thing is that if I close MB and do it all as separate processes, it works fine. I assume that I’m doing something wrong, but I don’t know what.
I attach a subset of the data I’m trying to join (join_testing) and the join table (Period_list). What I’m trying to do is join the PER1 in 'join_testing' to NAME in 'Period_list' and use it to populate PERCODE1 in 'join_testing' with the CODE field from 'PERIOD_list'. I then want to remove the original joins and then join PER2 to NAME in the joining table and use it to populate PERCODE2 etc, but I can’t even get to the first step.
Any help would be most appreciated.
Thank you.
