The NullAttributeMapper should be able to do that for you, something like this:
That top mapping rule, "If attribute value is" is empty right now, that's where you can select null, missing or empty for existing attribute values, in your case you want to check for "0", so leave the top one empty and put that in the second one.
The NullAttributeMapper should be able to do that for you, something like this:
That top mapping rule, "If attribute value is" is empty right now, that's where you can select null, missing or empty for existing attribute values, in your case you want to check for "0", so leave the top one empty and put that in the second one.
where i can find this nullAtttributeMapper ? is it something configured in transformer?
where i can find this nullAtttributeMapper ? is it something configured in transformer?
It's a transformer in FME Workbench, it should be in your Transformer Gallery and if you type in Quick Add it should show up.
The FME Desktop Advanced training course has a section on the NullAttributeMapper in its first chapter, that should give you some background info and if you work through the excercise it'll all be clear.
where i can find this nullAtttributeMapper ? is it something configured in transformer?
Okay , I checked that video. So are we suppose to add that nullAttrubiteMApper explicitly ? as it is old FMW file ... not sure if i can add any transformer in between ... It might hamper the processs. COuld you please help on it ?
Hello @fmekps , sounds like you are getting close! Your workflow should be 1. Read in source data 2. Add a NullAttrubiteMapper transformer (Transformers > Add Transformer) 3. Write out your results. I used an excel spreadsheet to test:
I've also attached before/after results:
Let me know if you get stuck anywhere. Hope this helps, Kailin.
Hello @fmekps , sounds like you are getting close! Your workflow should be 1. Read in source data 2. Add a NullAttrubiteMapper transformer (Transformers > Add Transformer) 3. Write out your results. I used an excel spreadsheet to test:
I've also attached before/after results:
Let me know if you get stuck anywhere. Hope this helps, Kailin.
Thanks much for the help & info! it worked