topic Re: Problems with relates and joins in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684766#M30276 <HTML><HEAD></HEAD><BODY><P>Here it is working first time in ArcMap. Same data. Same tables. Different result. Any idea what's up?</P><P></P><P><IMG alt="CaptureArcMAP.PNG" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/128931_CaptureArcMAP.PNG" style="width: 620px; height: 374px;" /></P></BODY></HTML> Tue, 29 Sep 2015 21:55:08 GMT RuskinHartley 2015-09-29T21:55:08Z Problems with relates and joins https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684759#M30269 <HTML><HEAD></HEAD><BODY><P>Seems like a simple task, but I am unable to join or relate a table created in Excel to a shape file of park boundaries. I've tried native Excel format, csv, and plain text files. File names are the same and there's common data. What am I doing wrong?!</P></BODY></HTML> Tue, 29 Sep 2015 00:38:36 GMT https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684759#M30269 RuskinHartley 2015-09-29T00:38:36Z Re: Problems with relates and joins https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684760#M30270 <HTML><HEAD></HEAD><BODY><P>The columns have to be of the same type... number to number,&nbsp; text to text.&nbsp; Can you confirm the data type of both?&nbsp; In excel and attribute table ... text is left justified unless someone has played around with the justification...numbers are right justified.</P><P>​</P></BODY></HTML> Tue, 29 Sep 2015 01:09:38 GMT https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684760#M30270 DanPatterson_Retired 2015-09-29T01:09:38Z Re: Problems with relates and joins https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684761#M30271 <HTML><HEAD></HEAD><BODY><P>Data appears to be the same type. Trying to relate text to text (4 letter NPS park codes) in many to many relationship.&nbsp; I see the relationship in the drop-down when I click the park boundary, but the related table isn't available. I could do this in ArcINFO, but an now stumped!</P></BODY></HTML> Tue, 29 Sep 2015 17:46:16 GMT https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684761#M30271 RuskinHartley 2015-09-29T17:46:16Z Re: Problems with relates and joins https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684762#M30272 <HTML><HEAD></HEAD><BODY><P>These tables have been added to arcmap?? if so, then a screen grab of the contents of a few rows might help</P></BODY></HTML> Tue, 29 Sep 2015 17:54:43 GMT https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684762#M30272 DanPatterson_Retired 2015-09-29T17:54:43Z Re: Problems with relates and joins https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684763#M30273 <HTML><HEAD></HEAD><BODY><P><IMG alt="relatescreenshop.jpg" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/128845_relatescreenshop.jpg" style="width: 620px; height: 387px;" /></P><P>Here's the two table in question and the pop-up that shows the relate, but no related data. Am I just not getting how this works??!</P></BODY></HTML> Tue, 29 Sep 2015 18:06:15 GMT https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684763#M30273 RuskinHartley 2015-09-29T18:06:15Z Re: Problems with relates and joins https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684764#M30274 <HTML><HEAD></HEAD><BODY><P>have you tried the relate in the reverse?&nbsp; Your file with the geometry should be the destination file and the one you are joining/relating is the secondary file.</P></BODY></HTML> Tue, 29 Sep 2015 20:23:53 GMT https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684764#M30274 DanPatterson_Retired 2015-09-29T20:23:53Z Re: Problems with relates and joins https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684765#M30275 <HTML><HEAD></HEAD><BODY><P>That's the way its set up and still no luck. Going to try it in ArcMap.</P></BODY></HTML> Tue, 29 Sep 2015 21:21:53 GMT https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684765#M30275 RuskinHartley 2015-09-29T21:21:53Z Re: Problems with relates and joins https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684766#M30276 <HTML><HEAD></HEAD><BODY><P>Here it is working first time in ArcMap. Same data. Same tables. Different result. Any idea what's up?</P><P></P><P><IMG alt="CaptureArcMAP.PNG" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/128931_CaptureArcMAP.PNG" style="width: 620px; height: 374px;" /></P></BODY></HTML> Tue, 29 Sep 2015 21:55:08 GMT https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684766#M30276 RuskinHartley 2015-09-29T21:55:08Z Re: Problems with relates and joins https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684767#M30277 <HTML><HEAD></HEAD><BODY><P>It is hard to tell since the interfaces are so different.&nbsp; Especially if you confirmed the order and the face that you were doing a relate in both.. strange...perhaps other eyes may help, since I didn't see any bug issues reported...and this is common enoough operation that surely it would have been spotted by now​</P></BODY></HTML> Tue, 29 Sep 2015 22:33:16 GMT https://community.esri.com/t5/arcgis-pro-questions/problems-with-relates-and-joins/m-p/684767#M30277 DanPatterson_Retired 2015-09-29T22:33:16Z