Skip to main content
  • EN

CaptureI am hoping someone may have suggestion as to why a FeatureJoiner fails to join on 1 attribute only.

  • Left input: table of records, including CouncilRegion attribute
  • Right input: polygon feature class with Region's Name

The transformer successfully joins all records from the left input table, to the feature class..., apart from the table records in "Hawke's Bay"

Capture2Capture3The join is successful for all other records.

I have trimmed any potential white space at the end of the attributes.

Anyone can think of where the problem may lie, what test I could do to ensure Hawke's Bay records do join?

Many thanks

Hi @Alice van der Bruggen​ 

I'm not sure if it's just my eyes but I think the 'apostrophes' look different. The apostrophe on the left features looks like it a prime symbol as the symbol angles slightly to the left while the apostrophe on the right features points straight down.

You can test this by extracting the apostrophe (SubstringExtractor, start and end index=5) and using the CharacterCodeExtractor to find the character code. A regular apostrophe should return 39 compared to 8242 for a prime symbol.

Hi @debbiatsafe​ ,

Thank you very much for your answer, and suggestion to use SubstringExtractor and CharacterCodeExtractor, this highlighted the issue!

The left input's apostrophe returns character 8217.

The right input's apostrophe returns character 39.

Now the mismatch is explained, I can fix this. Thanks a lot!

Reply


Community Stats

30,177
Posts
114,556
Replies
37,843
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.