Skip to main content
Solved

FeatureJoiner - 1 attribute fails to join

avdb
Contributor
Forum|alt.badge.img
  • avdbContributor
  • Contributor

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

Best answer by debbiatsafe

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.

View original
Did this help you find an answer to your question?

2 replies

debbiatsafe
Safer
Forum|alt.badge.img+20
  • debbiatsafeSafer
  • Safer
  • Best Answer
  • May 20, 2021

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.

avdb
Contributor
Forum|alt.badge.img
  • avdbContributor
  • Author
  • Contributor
  • May 20, 2021

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


Helpful Members This Week

Community Stats

31,525
Posts
119,505
Replies
39,151
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.