Skip to main content
Question

SchemaMapper Advance Mapping Create Whitespace before evaluating data value


alexlynch3450
Contributor
Forum|alt.badge.img+14

Hello All,

I’m having an issue where SchemaMapper prefix whitespace (space) when using fmeexpression=.

I attached a sample workspace and would appreciate if anyone could test before submitting ticket.

 

This issue came apparent after upgrading to FME 2023. for example: col0=’2’, col1=’3’-->using “fmeexpression=@Evaluate(@Value(col0)+@Value(col1))” returns value “ 5” or “fmeexpression=@Evaluate(@Value(col0)@Value(col1))” returns value “ 23”

Previously, using “@Evaluate([return “@Value(col0)@Value(col1)])” returns value “23”. 

I know 2023 introduced new functionality to SchemaMapper, per transformer help doc and https://support.safe.com/hc/en-us/articles/25407523665165-SchemaMapper-Advanced-Schema-Mapping

 

Would appreciated if someone could test before submitting ticket.
 

Output


 

SchemaMapperDoc

 

3 replies

debbiatsafe
Safer
Forum|alt.badge.img+20
  • Safer
  • August 6, 2024

Hello @alexlynch3450 

I’m sorry you have encountered this issue. This behaviour has already been reported and is tracked as FMEENGINE-82741. I will update this thread once this has been resolved.

The workaround is to use an AttributeTrimmer after the SchemaMapper to remove the leading whitespace. I hope this information helps!


alexlynch3450
Contributor
Forum|alt.badge.img+14
  • Author
  • Contributor
  • August 7, 2024

dang, that’s counterproductive. I’d have to add both attributeExposer and AttributeTrimmer to every attribute occurrence. Quite literally defeats dynamic writing. please please please update this. 


debbiatsafe
Safer
Forum|alt.badge.img+20
  • Safer
  • February 1, 2025

I’m please to announce that the behaviour of whitespace inserted at start of attribute value if the target attribute value uses FME function calls has been fixed in 2025.0 betas.

You can download betas installers at https://fme.safe.com/downloads/#beta


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings