Hexagon Geospatial
MENU

GeoMedia

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
Contributor
Posts: 26
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.

Regular Contributor
Posts: 207
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

Staff
Posts: 132
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.

 

Contributor
Posts: 26
Registered: ‎04-24-2017

Re: Geomedia desktop, join duplicate records

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

Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Service Request through our Support Portal.