Originally posted by: SystemAdmin

The following map rules all output the value of A:
=A
=IF(PRESENT(A), A)
=EITHER(A, NONE)

Using the same input data, these map rules always output the value of FMap(B):
=IF(PRESENT(A),
A,
FMap(B))
=EITHER(A, FMap(B))

I'm drawing a blank on this. How do I output the value of A when present and the output of FMap(B) when it is not?

Thanks, Jim Divoky
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

I forgot to add that A is a field within the complex object, B.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

I've simplified my map rules and my results still make no sense.

=Date - The map rule returns the date value 20120902, 20120903, etc., as the parent FMap loops.

If I change the map rule to:
=EITHER(Date, TEXTTODATE("20121116")) - The map rule returns 20121116 on every loop.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Could this be a "data binding" issue? Do a search on this forum for discussions on this topic, it might help!
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

>> Could this be a "data binding" issue?

Thanks for the suggestion. That's what I thought initially so I passed a second copy of the input without good results. Then I simplified the map rule in the functional map and still had an issue.

In the input, the value of Date is present 5 times and missing 5 times. The following occurs with each of these map rules:

= Date Date is present 5 times in the output and missing 5 times.

= EITHER(Date, NONE) Date is present 5 times in the output and missing 5 times.

= EITHER(Date, TEXTTODATE("20121116")) All ten Date fields contain 20121116.

Now I've eliminated the EITHER function and am using a LOOKUP function. It appears to be working as expected. I still have to add three more conditions to the map rule though. I hate ACORD data!
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender