Skip to main content
  • EN

I'm a little confused and hope someone can help me understand why the Feature Information window in the FME Data Inspector shows a value in an attribute, yet the same feature attribute in the Table View shows as <missing>

I noticed this because I have a tester that is comparing the nominal focal length fields (one is from a spreadsheet the other is from the database), and this feature is failing at the tester. I knew it had a value in the spreadsheet and database so I used the Inspector to check it.

I was stumped because in the Feature Info window, 'NOMINAL FOCAL LENGTH' and 'nominal_focal_length' show the same value, so the Tester should have passed the feature.

I then checked the Table View and it shows that 'NOMINAL FOCAL LENGTH' attribute has '<missing>', which must be why my tester is failing this feature.

So I'm a tad stumped.

The attribute name shown on the Feature Information in your screenshot is "NOMINAL FOCAL LENGTH (mm)" that contains the units "(mm)", whereas the name of the missing attribute shown on the Table View doesn't have the units. They are different attribute names.

I guess the "NOMINAL FOCAL LENGTH (mm)" is not exposed on the Workbench Canvas.

The attribute name shown on the Feature Information in your screenshot is "NOMINAL FOCAL LENGTH (mm)" that contains the units "(mm)", whereas the name of the missing attribute shown on the Table View doesn't have the units. They are different attribute names.

I guess the "NOMINAL FOCAL LENGTH (mm)" is not exposed on the Workbench Canvas.
Thank you! I thought I was going mad! I must have dismissed the (mm) as something the Inspector had added.

 

 

Hi, it looks like NOMINAL_FOCAL_LENGTH is real64 number and nominal_focal_length is string (encoded utf-8). Cast them to @double in AttributeCreator to be able to compare them

Hi, it looks like NOMINAL_FOCAL_LENGTH is real64 number and nominal_focal_length is string (encoded utf-8). Cast them to @double in AttributeCreator to be able to compare them

I don't think it's essential to cast the value. By default (Mode: Automatic), FME compares left and right operands in a test clause as numbers if possible, even if their internal data type was character string. See also the help on the Tester (description on the Mode).

 

 

Reply


Community Stats

30,186
Posts
114,572
Replies
37,849
Members
Terms & ConditionsCookie 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.