Solved

FeatureJoiner - 1 attribute fails to join

A

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

icon

Best answer by debbiatsafe 20 May 2021, 23:59

View original

2 replies

debbiatsafe
Rank
Userlevel 3
Badge +17

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.

A

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

28,670
Posts
109,366
Replies
36,531
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.