Skip to main content

Hi all,

I have two dataset (csv and shp) linked by a common field (COMM_ID).

Using the readers and then a FeatureMerger, a lot of records are not linked.

When I convert both to Excel, and I try to merge again, all of them find a proper relationship. Why this happens?

In the attachment, both unused suppliers and unmerged requestor.

TIA

Roberto

My guess would be there are maybe some non printing characters or similar so whilst the values look identical they aren't and that converting to excel eliminates these which is why it works afterwards.


My guess would be there are maybe some non printing characters or similar so whilst the values look identical they aren't and that converting to excel eliminates these which is why it works afterwards.

@ebygomm​ ,

I tried to check the encoding.

I get this two different results for one of the unmerged items.

I've encoded the field after a trim.

The term AD is encoded in two different way.

AD (csv) = 41004400

AD (shape) = 41004400000000000000000000000000000000000000000000000000

 

Regards,

Roberto

 

 


Reply