topic How to join an excel data table to a polyline shapefile (1:M) in Mapping Questions https://community.esri.com/t5/mapping-questions/how-to-join-an-excel-data-table-to-a-polyline/m-p/185901#M2029 <HTML><HEAD></HEAD><BODY><SPAN>I have a polyline shapefile that represents the spatial location of survey transects (broken into 168 segments) and an excel table of many butterfly observations that I would like to spatially display in ArcMap 10.&nbsp; I made sure that the excel table and the shapefile both have a common text field (called T_S that represents the Transect and Segment numbers).&nbsp; But when I join the excel table to the transect shapefile, I end up with the same 168 records, only two of which are populated with the data I want to map out.&nbsp; I tried a relate function, but had the same result.</SPAN><BR /><BR /><SPAN>Any suggestions?&nbsp; Any input is appreciated!</SPAN></BODY></HTML> Tue, 17 Jul 2012 00:04:29 GMT LisaRandolph 2012-07-17T00:04:29Z How to join an excel data table to a polyline shapefile (1:M) https://community.esri.com/t5/mapping-questions/how-to-join-an-excel-data-table-to-a-polyline/m-p/185901#M2029 <HTML><HEAD></HEAD><BODY><SPAN>I have a polyline shapefile that represents the spatial location of survey transects (broken into 168 segments) and an excel table of many butterfly observations that I would like to spatially display in ArcMap 10.&nbsp; I made sure that the excel table and the shapefile both have a common text field (called T_S that represents the Transect and Segment numbers).&nbsp; But when I join the excel table to the transect shapefile, I end up with the same 168 records, only two of which are populated with the data I want to map out.&nbsp; I tried a relate function, but had the same result.</SPAN><BR /><BR /><SPAN>Any suggestions?&nbsp; Any input is appreciated!</SPAN></BODY></HTML> Tue, 17 Jul 2012 00:04:29 GMT https://community.esri.com/t5/mapping-questions/how-to-join-an-excel-data-table-to-a-polyline/m-p/185901#M2029 LisaRandolph 2012-07-17T00:04:29Z Re: How to join an excel data table to a polyline shapefile (1:M) https://community.esri.com/t5/mapping-questions/how-to-join-an-excel-data-table-to-a-polyline/m-p/185902#M2030 <HTML><HEAD></HEAD><BODY><SPAN>First - check type of fields you join. For example - text type can't join with short integer. Maybe you have mixed types in Excel.</SPAN><BR /><SPAN>Second - attach file in order we could check it.</SPAN></BODY></HTML> Tue, 17 Jul 2012 06:09:25 GMT https://community.esri.com/t5/mapping-questions/how-to-join-an-excel-data-table-to-a-polyline/m-p/185902#M2030 MichalBrach 2012-07-17T06:09:25Z Re: How to join an excel data table to a polyline shapefile (1:M) https://community.esri.com/t5/mapping-questions/how-to-join-an-excel-data-table-to-a-polyline/m-p/185903#M2031 <HTML><HEAD></HEAD><BODY><SPAN>I have double checked the field types that I am trying to join (in ArcCatalog) and they are both text types.&nbsp; The common field for both is "T_S".&nbsp; Attached are both the .xlxs file (spreadsheet called "SCS"), and the .shp file zipped.&nbsp; </SPAN><BR /><BR /><SPAN>And THANK YOU so much for the reply!&nbsp; I know this should not be a difficult task, but I keep running into walls.</SPAN><BR /><BR /><SPAN>Lisa Randolph</SPAN></BODY></HTML> Tue, 17 Jul 2012 14:42:03 GMT https://community.esri.com/t5/mapping-questions/how-to-join-an-excel-data-table-to-a-polyline/m-p/185903#M2031 LisaRandolph 2012-07-17T14:42:03Z Re: How to join an excel data table to a polyline shapefile (1:M) https://community.esri.com/t5/mapping-questions/how-to-join-an-excel-data-table-to-a-polyline/m-p/185904#M2032 <HTML><HEAD></HEAD><BODY><SPAN>Try to save you .xlsx as .csv and then use Add Join or Join Field to map the joined information. Does that work for you?</SPAN></BODY></HTML> Tue, 10 Dec 2013 14:18:07 GMT https://community.esri.com/t5/mapping-questions/how-to-join-an-excel-data-table-to-a-polyline/m-p/185904#M2032 DanLee 2013-12-10T14:18:07Z