Skip to main content

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?


Reply