I am trying to map null orphan values to a default value of 0 after an outer join has occurred. Is this possible?
Here is the code:
"MIA CASE SEQ" as [MIA CASE SEQ-MIA_CASE_SEQ],
"MIA_CASE_SEQ" as [MIA CASE SEQ-MIA_CASE_SEQ],
**Now, how do I go about applying a map to this outerjoined table? I need to make sure that all the in all the instances that there was not a join on the [MIA CASE SEQ-MIA_CASE_SEQ] that the corresponding orphan nulls for AU, MT, and Y = 0. **