One to Many Join or Relates?

FrancisHourigan1

I Have a polygon feature class with vineyard name 6 letter IDs. I want to join lab data taken for each location but I need to join the data or relate the lab data table in a one to many fashion. The problem is that I want to use a concatenated field in the polygon data that includes the vineyard ID the block and the subblock. I cannot create a new field in the lab data I want to relate it to.  Is there a way to create a temporary attribute field that I can concatenate (in model builder or python) to make the related data connection?

Also, I usually use Pro, but the lab table connection is only available in ArcMap. So I need to build the model or script for ArcMap.

Thanks!

Xander Bakker‌ is there an an example python script for something like this?

XanderBakker

Hi Francis Hourigan ,

So, you have a polygon layer VineyardSubBlocks and a field called "BIMS Vineyard Code" (this is the alias, you will have to use the real fieldname in the code). an example value for this code would be "VNWOO1565151".

In a table called "BIMSPRG.FHARVDTL" you have a couple of fields that should be concatenated:  VINEYARD_CODE (VNWOO), VINEYARD_BLOCK (15651) and VINEYARD_SUBBLOCK (51) to get that same code. What you are trying to obtain is the LAB_CODE, which is some case may have multiple records related. In that case you want to obtain the list of values like: "BXR, TA, PH". Is that correct? In which field of the VineyardSubBlocks do you want to store the result?