I have several models that perform calculations with joins.
These calculations require you to enter the name of the joined table, then it's field name.
[FIELD] = [JOINEDTABLE.FIELD]
What I have done is to give "hard coded" names to output tables so they are always the same:
This makes it easier to do the calculation, but once in a while the table isn't deleted (model bombs) AND a lock gets placed on it so it can't be overwritten.
There are ways around this, of course, but what I would like to do is create unique table names, but I don't know how to extract just the table name in ModelBuilder (in Python os.path.basename(full table path) does the trick).
I tried [FIELD] = [%tablename%.FIELD], but of course that creates a calculation string like this:
[FIELD] =
I think I'm close, but just need a little nudge in the right direction.
Thank you for your time,