Skip to main content
Solved

FeatureJoiner - 1 attribute fails to join

  • May 20, 2021
  • 2 replies
  • 146 views
avdb
Contributor
Forum|alt.badge.img
  • avdbContributor
  • Contributor
  • 3 replies

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

debbiatsafe
Safer
Forum|alt.badge.img+21
  • debbiatsafeSafer
  • Safer
  • 648 replies
  • 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
  • 3 replies
  • 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!

Community Stats

32,070
Posts
121,772
Replies
39,698
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.