Rank: Newbie
Joined: 11/18/2009
Posts: 2
Location: Texas
|
Hi,
I've used XML SPY awhile and just discovered Mapforce in Altnova mission kit and am loving it, awesome tool for mapping from DB to schema. The only problem I'm having is figuring out some of the conditional mappings and transformations.
I have a varchar field which some genius decided to populate with an empty string on inserts instead of leaving it null. The schema element this maps to is optional. So if the value is spaces, I want to treat it like null and not include the output element rather than create the element with an empty string value. What's the best/easiest way to do this?
Thanks!
|
Rank: Newbie
Joined: 11/18/2009
Posts: 2
Location: Texas
|
OK, answered my own question:
Insert:
empty string constant
normalize-space function
equal function
filter
connect:
db column to normalize string
normalize result and constant to equal
equal result to filter bool
db column to filter node
filter on-false to schema element
suspect I will need a UDF for this as there will be lots of empty strings to strip.
YMMV
|
