Skip to main content
Solved

FeatureJoiner case insensitivity

  • March 6, 2019
  • 1 reply
  • 372 views
L
Forum|alt.badge.img

Hello,

I have data set that I need to join attributes from csv file. I am joining with ID that is combination of letters and number e.g. tk14b.

Problem is with letters because i have mix of upper and lower case but tk14b is, for me, same as Tk14B and every other possible mix.

Is it possible to set FeatureJoiner to be case insensitive? Or, is there any other way to join my data set with attributes from CSV file?

 

Thank you in advance.

Best answer by ebygomm

You can use a FeatureMerger - convert the Requestor and Supplier to uppercase - features will be merged if they match, but the attributes you are joining on won't actually be changed.

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.

1 reply

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3429 replies
  • Best Answer
  • March 6, 2019

You can use a FeatureMerger - convert the Requestor and Supplier to uppercase - features will be merged if they match, but the attributes you are joining on won't actually be changed.

Community Stats

32,083
Posts
121,826
Replies
39,717
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.