I'm writing to MongoDB - using the tMongoDBOutput using the generate JSON Document option. I'm doing a Set action to fill in addresses.
Input fields (all are string)
address1
address2
city
state
The target collection has a unique integer value CustomerID which is used for the "query".
Under the document there is
rootTag
data
CustomerID
addresses (@class array)
row5 (object, loop element)
address1
address2
city
state
with the obvious mapping.
This works fine... except when address2 is null ... I get the address2 output in Mongo as an 0 element array! The advanced option "create empty element if needed" is not checked.
What I want is either address2 being an empty string, or not having an address2 element if there is no address2 data. I tried in a tMap to convert null to "", but got the same result.
