I have a feature class that contains polygon features with a unique ID column. This shapefile is to be joined with a CSV table that I've exported to a file geodatabase table. The unique identifier in the table is the tuple (IDX, UID), there exists multiple columns with the same UID.
I would like to join the polygon feature and the table based on the relation ID=UID using ArcPy. That relation however is a one-to-one relation and I would like it to be a one-to-many relation so that one record in the polygon feature class table is joined with multiple records in the table.
Any ideas on how to do this using ArcPy?