topic Re: In-memory join does not return One-To-Many in ArcGIS Pro Questions

In-memory join does not return One-To-Many

FrédéricSCHETTINI — Fri, 26 Jun 2020 14:53:58 GMT

Hi,

I am trying to join an in-memory Feature Class and an in-memory Table.

I get only one row of the FC joins to one row of the table where the input and output join fields match

It seems that is One-To-Many Join.

Performing the same join with the Feature Class and Table in the GDB, I get the expected resul meaning One-To-Many Join.

I have tested both using arcpy and ArcGIS Pro.

Is there a way to have the join using memory workspace returns an One-To-Many join?

Thank you

Frédéric.

Re: In-memory join does not return One-To-Many

NobbirAhmed — Fri, 26 Jun 2020 15:27:57 GMT

Are you using Add Join tool?

Re: In-memory join does not return One-To-Many

JoeBorgione — Fri, 26 Jun 2020 16:27:10 GMT

How do you create a one to many join?

Re: In-memory join does not return One-To-Many

DavidPike — Fri, 26 Jun 2020 19:04:58 GMT

Can you persist it in a scratch workspace?

Re: In-memory join does not return One-To-Many

NobbirAhmed — Fri, 26 Jun 2020 19:23:44 GMT

If the layer to which records are joined is a Feature Class then you can persist by using Copy Features (management) tool - if it is a Table then you can use Copy (management) tool.

You can save to scratch workspace if you set one in Analysis environment:

Re: In-memory join does not return One-To-Many

NobbirAhmed — Fri, 26 Jun 2020 20:05:35 GMT

If you are in Geoprocessing world then you have to use Spatial Join for one-to-many option. Add Join doesn't have that option.

GDB .Net SDK might have this option to get it done using PRo SDK - but I'm not knowledgeable of GDB SDK. I'll try to find out.

Re: In-memory join does not return One-To-Many

JoeBorgione — Fri, 26 Jun 2020 20:08:32 GMT

Okay; that's what I thought but when you asked the OP if he was using the Add Join tool I thought to myself 'Have I been living under a rock and missed this?'

Re: In-memory join does not return One-To-Many

FrédéricSCHETTINI — Mon, 29 Jun 2020 17:13:07 GMT

Here the tests I have done

# TEST 1: ADD JOIN USING MEMORY FC AND TABLE
#COPY TABLE IN MEMORY
arcpy.conversion.TableToTable("HERE_DA_Bardonechia_A32_SS335_Vittoria", "memory", "HERE_DA_Bardonechia_A32_SS335_VittoriaMemory", .........)

#COPY FC IN MEMORY
arcpy.conversion.FeatureClassToFeatureClass(r"A32BardonnexOulx\StreetsA32BardonecchiaOulx", "memory", "StreetsA32BardonecchiaOulxMemory", .......)

#ADD JOIN BETWEEN MEMORY FC AND MEMORY TABLE
arcpy.management.AddJoin("StreetsA32BardonecchiaOulxMemory", "LINK_DIR_FROM", "HERE_DA_Bardonechia_A32_SS335_VittoriaMemory", "LINK_DIR", "KEEP_COMMON")

# => 37 records joined in StreetsA32BardonecchiaOulxMemory

# TEST 2: ADD JOIN USING GDB FC AND TABLE
arcpy.management.AddJoin(r"A32BardonnexOulx\StreetsA32BardonecchiaOulx", "LINK_DIR_TO", "HERE_DA_Bardonechia_A32_SS335_Vittoria", "LINK_DIR", "KEEP_COMMON")

# => 4 536 records joined in StreetsA32BardonecchiaOulx (expected result)

I get only 37 rows joined (each feature is joined only once) if I used memory FC and table.

Thanks for your help.

Re: In-memory join does not return One-To-Many

NobbirAhmed — Mon, 29 Jun 2020 18:19:59 GMT

Hi Frédéric SCHETTINI , could you please share your data? I would like to test. You don't need to share the whole dataset - remove fields that I don't need for testing.

Thanks, Nobbir (GP SDK Team)

Re: In-memory join does not return One-To-Many

NobbirAhmed — Mon, 29 Jun 2020 18:20:56 GMT

My email is: nahmed@esri.com