Skip to main content
  • EN

Hi, i’m working on water treatment facilities. I’ve to categorize them in order to write a excel file which lists the existing and some deliverable.  

I’ll try to explain the best i can : basically the data are from a gdb,  i’ve a tester to sort depending on categories. Some cat can have missing/null values, i need to “force” those missing values into the translation in ordrer to write the corresponding categories in the excel files.

my situation now is that the missing values given they’re not written shift the writting in my writer and then do not correspond with their according row.

i’ve 9 differents categories so 9 row but when i’ve just 5 filled categories, i’ve those 5 written but it change the alphabetical order in the written row so the categories dosent match the row. 

How can i say to the translator “if i’ve no values write the default value “0” else “no action””

 

Thanks, hope i’ve been clear enough

Instead of the Tester you can use an AttributeManager with a conditional value for that attribute. That essentially incorporates a Tester in the AttributeManager.

Maybe the NullAttributeMapper can be of help here. This transformer can replace Null values or empty strings with another value, like 0.

Instead of the Tester you can use an AttributeManager with a conditional value for that attribute. That essentially incorporates a Tester in the AttributeManager.

Thanks for the answer. The difficult part of it is that there’s multiple attribute to deal with, the unique attribute which group all of them comes later (where i could make the conditionnal value) into the translation and is already empty. I struggle finding the good logic telling him “if i’ve no values between with theses 4 attributtes write the default value “0”

Maybe the NullAttributeMapper can be of help here. This transformer can replace Null values or empty strings with another value, like 0.

Hi thanks for the answer. yes thaught about it but since the translation doesn’t even aknowlege the empty rows (it just skips it) i can’t mapper on this particular row/attribute. do you know how to force a non skip and add an empty row ? 

I'm unclear what you mean by empty rows here.

Can you provide some sample data?

Hi, sorry for the late. Ok i’ll train explain the best i can with screenshot : 

 

I’ve 4 categories : 

  • water system components
  • connection terminal 
  • manholes
  • water treatment plant

as you can see, the output only give me 2 values because some values are empty/null. I want to be able to say “If the values are empy/null, the default value is 0” but i’ve to say this for each categories. I know it has to be an attribute manager instead of a tester but i struggle to translate in FME

 

 

At the start of each category add a NullAttributeMapper that changes Null values or empty strings to 0.

Reply


Community Stats

30,351
Posts
115,342
Replies
38,082
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.