one-to-many with R

05-16-2019 04:35 AM
Occasional Contributor III


I would like to do a one-to-many join from within R.

I have an shapefile with N features. I have a table with 12xN records. I would like to join the shapefile with the table so that there is a one-to-many relationship. 

It is possible to write in R script, to join my table to a shapefile? I am unable to find ways to join data table as one-to-many.

Any guidance please.

thank you

Tags (1)
0 Kudos
1 Reply
Esri Regular Contributor

If you're just performing an aspatial join (based on a shared column), you can use the default `merge` method from R to join, see for example this post. Since you have ArcGIS available, you may also want to perform this beforehand, you can use Join Field, including via ArcPy.

0 Kudos