Solved

FeatureJoiner case insensitivity

  • 6 March 2019
  • 1 reply
  • 46 views

Badge

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.

icon

Best answer by ebygomm 6 March 2019, 13:31

View original

1 reply

Badge +10

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.

Reply