I have a shape file that contains a total of 479 polylines and each line is associated with SiteID as shown below.
I have another data that contains more than 88000 rows of data, each row contains various measurements along with "SiteID" (first column in the figure below). And of course there are many rows having identical SiteID.
What I'd like to do is to join this data with 479 polylines by matching the SIteID so that each data entry can be shown on the map as a line containing many rows of information many the same SiteID. I used join function but it didn't work.
Any suggestion is greatly appreciated!!