final result
You will not have error if you configure correctly in previous steps
I list error here just show how to identify error and fix it.
Above fix does not work
This is what I mean
empty, null, also cause error like this
Warning: FME have unfixed bug. In order to identify empty string, you have to use StringLength(field name) = 1
Empty string length should be 0, but I have to follow FME's bug, use '1' as identifier to find all empty string
