GeoMedia Discussions

Search for an answer, post a question, or answer other users' questions in our GeoMedia support discussions. This discussion board is a great way to collaborate with industry peers around the world. It is intended for discussion and support of the GeoMedia Desktop and Add-on applications.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Contributor
Posts: 35
Registered: ‎04-24-2017
Accepted Solution

Geomedia desktop, join duplicate records

[ Edited ]

Hello.

I'm trying to get a inner join table (Id vs Id), keeping only de left table records with some columns from rigth table.

So when I get the analyis result, is there's more records than original (left) table, because rigth table repeats Id.

So, here's the question:

 

Why is happening this, or how can I configure to get only the first record from rigth table?

 

My left table is an excel 97 list and my rigth table is a "Centerpoint" query from polygons feature class.

 

attached you'll find an image to try to clarfy this.

 

Regards.

Highlighted
Regular Contributor
Posts: 217
Registered: ‎05-25-2016

Re: Geomedia desktop, join duplicate records

Hi

 

Are you sure the values in column ID of the right table are unique?

I think, some values must occur several times.

 

Regards, hesrah

Highlighted
Staff
Posts: 138
Registered: ‎05-26-2016

Re: Geomedia desktop, join duplicate records

[ Edited ]

You are getting the correct result for the Join as you have repetative id's on the right side, none of the Join types will give you the result you desire. Effectively you want to do a DISTINCT JOIN if you were doing a Native query. However as you are using Access, try an Aggregation.

 

For example

 

Aggregate the two features,

 

DON'T select Spatial Aggregation, disable if checked

Select the Attribute Aggregation tab and pair  - id/id2

Select the Output Tab with Resolution Operator: First

Create an Output Functional Attribute FIRST(Detail.id2) to prove

or whatever attributes you require.

 

Highlighted
Contributor
Posts: 35
Registered: ‎04-24-2017

Re: Geomedia desktop, join duplicate records

Thanks a lot, I'll try and report any issue.