topic Re: Is there a way to join based on contains, or a workaround? in ArcMap Questions https://community.esri.com/t5/arcmap-questions/is-there-a-way-to-join-based-on-contains-or-a/m-p/545893#M1134 <HTML><HEAD></HEAD><BODY><P>As long as the second table doesn't have repeats of a deed in more than one entry it will be pretty easy with an update cursor. I'd probably just add a new column on the first table which the cursor would then add the matching oid of the second table to base the join on.</P><P>I can write the script up if this is what you need?</P></BODY></HTML> Fri, 17 Apr 2020 20:09:34 GMT DavidPike 2020-04-17T20:09:34Z Is there a way to join based on contains, or a workaround? https://community.esri.com/t5/arcmap-questions/is-there-a-way-to-join-based-on-contains-or-a/m-p/545892#M1133 <HTML><HEAD></HEAD><BODY><P>I need to transfer information from&nbsp;a table to a feature layer's table. Only problem is that the join isn't perfect. One table has multiple deeds in the same entry while the other table has each instance of the deed as separate entries. Here are pictures if what I'm saying doesn't make sense:</P><P></P><P><IMG alt="" class="jive-emoji image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/489085_deed1.PNG" /><IMG alt="" class="jive-emoji image-2 jive-image" height="178" src="https://community.esri.com/legacyfs/online/489119_deed2.PNG" width="151" />(I need to transfer the data from the second picture's table to the first's, so I need to somehow breakdown the deeds into separate entries.)</P><P>These are the only two fields that are remotely similar in each table. I know I can manually enter the data, but there's thousands of entries. Is there a way to join these two tables based on a contains requirement or another suitable workaround?&nbsp;<SPAN>Help&nbsp;</SPAN><IMG src="https://community.esri.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Fri, 17 Apr 2020 18:33:35 GMT https://community.esri.com/t5/arcmap-questions/is-there-a-way-to-join-based-on-contains-or-a/m-p/545892#M1133 Savannah 2020-04-17T18:33:35Z Re: Is there a way to join based on contains, or a workaround? https://community.esri.com/t5/arcmap-questions/is-there-a-way-to-join-based-on-contains-or-a/m-p/545893#M1134 <HTML><HEAD></HEAD><BODY><P>As long as the second table doesn't have repeats of a deed in more than one entry it will be pretty easy with an update cursor. I'd probably just add a new column on the first table which the cursor would then add the matching oid of the second table to base the join on.</P><P>I can write the script up if this is what you need?</P></BODY></HTML> Fri, 17 Apr 2020 20:09:34 GMT https://community.esri.com/t5/arcmap-questions/is-there-a-way-to-join-based-on-contains-or-a/m-p/545893#M1134 DavidPike 2020-04-17T20:09:34Z