Skip to main content
Question

Feature Joiner on number not joining?

  • January 20, 2026
  • 4 replies
  • 26 views
rjohnsoncos
Contributor
Forum|alt.badge.img+2

I am trying to join SQL data with csv data.  The field coming from SQL is uint32.  The field in the CSV is Char but converted to uint32.  Im joining the sets on this field and I get no matches.  here is the SQL data:

Here is the CSV date after conversion to uint32:

Feature Joiner information:

Ive tried the following:

  • Changing comparison mode between numeric and automatic - no change
  • Changing both datasets to be char(4) - no change
  • used Feature Merger - no result change.

What am I missing here?

      4 replies

      ebygomm
      Influencer
      Forum|alt.badge.img+46
      • ebygommInfluencer
      • Influencer
      • January 20, 2026

      Have you tried trimming the attributes?

       

      The number in your SRField_Id screenshot looks further away from the right hand margin than in the CustFieldID screenshot (Although I’d still expect them to match even if comparison mode was numeric)

      rjohnsoncos
      Contributor
      Forum|alt.badge.img+2
      • rjohnsoncosContributor
      • Author
      • Contributor
      • January 20, 2026

      I have tried the trim function with both the numeric and char versions that I have tried.  It did not seem to make a difference.

      rjohnsoncos
      Contributor
      Forum|alt.badge.img+2
      • rjohnsoncosContributor
      • Author
      • Contributor
      • January 20, 2026

      also, im using an attributemanager to convert that char to uint32 - so I would think it would drop spaces for the conversion?

      rjohnsoncos
      Contributor
      Forum|alt.badge.img+2
      • rjohnsoncosContributor
      • Author
      • Contributor
      • January 20, 2026

      heres a bigger picture. 

       

      Community Stats

      32,312
      Posts
      122,610
      Replies
      40,021
      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.