Join by [Starts with]

Question

I'm trying to join two tables where my matching condition is a field from one table should match the start of a field in the other table.

I could not find such an option in the parameters for the Join tool. I could also not find a tool that seemed like would do this.

The issue is that the length of the field to be matched is variable so I cannot really create a new field with a formula to match that either.

Or else could i make a Join using contains()?

The field in table Left would look like:

RecordNameValue1Sesame street122Ocean Drive323Mile End Road

1.5

My table Right would have the following format:

RecordAddressOwner1Sesame street 5Cookie Monster2Sesame street 5 - 5th floorCookie Monster's mother in law3Ocean Drive 12112Eminem4Mile End RoadDavid Hasselhof5Mile End Road 1235BLuke Skywalker

Any ideas?

Thanks!

alexnajm · Accepted Answer

Sounds like a Find Replace tool! It has "Beginning of Field" capabilities, as well as case insensitivity to help out. Here's a workflow to illustrate:

Felipe_Ribeir0 · Accepted Answer

Hi @ciplionej

There are some ways to go around this, one of them is by using an append + contains filter:

Luke_C · Accepted Answer

Hi @ciplionej

As others have said, that functionality is not in the join tool. Here's one option