Skip to main content

The first dataset has 10500 objects ( a table with x,y id, date,etc. etc.)

The second dataset 7000 object s )(a table with x,y,id ,,date, adress etc.etc.)

Based on the x and y we would like to get a combined file as a result.

Where all 10,000 objects from the first dataset are located at the closest object to an address point.

A list of these..

 

It seemed logical to us to use the transformer neighbor finder for this. But this doesn't work.

 

ideas more than welcome

 

 

Johan

 

Yes,  neighbor finder is the correct transformer to use, however, when you say you have "point data" is this just data from a CSV? Are the x and y being used for the geometry i.e., can you see points on the map in the FME Data Inspector?

 

The other thing to check is that the Coordinate systems between the two datasets is the same.

 

If you still can't figure it out then post some screen shots of the configuration you're using for the NeignorFinder


Yes,  neighbor finder is the correct transformer to use, however, when you say you have "point data" is this just data from a CSV? Are the x and y being used for the geometry i.e., can you see points on the map in the FME Data Inspector?

 

The other thing to check is that the Coordinate systems between the two datasets is the same.

 

If you still can't figure it out then post some screen shots of the configuration you're using for the NeignorFinder

Yes, one set comes from CSV/Excel and the other from an oracle database.

Both sets visualized with "Vertexcreator". and viewed with visual preview (points with the available data)

 


Yes, one set comes from CSV/Excel and the other from an oracle database.

Both sets visualized with "Vertexcreator". and viewed with visual preview (points with the available data)

 

Ok then there must be something a little off with the way you are configuring the NeigborFinder.

 

Ahh I just realised that by default the NeigborFinder isn't set to merge the attribtues.

 

double check that it's turned on in your workspace

 

image 

 


Yes, one set comes from CSV/Excel and the other from an oracle database.

Both sets visualized with "Vertexcreator". and viewed with visual preview (points with the available data)

 

imageThat's probably why I can't find it.

I see the above

 


Yes, one set comes from CSV/Excel and the other from an oracle database.

Both sets visualized with "Vertexcreator". and viewed with visual preview (points with the available data)

 

Ok yeah - Then turning on the Attribute Accumulation should get those addresses on to your base points then


Yes, one set comes from CSV/Excel and the other from an oracle database.

Both sets visualized with "Vertexcreator". and viewed with visual preview (points with the available data)

 

Thanks. I think it is working.

It's great that you could support me

 


Reply