Originally posted by: SystemAdmin

I am in a situation where I need to retrieve & display record three times based on the different conditions in a functional map.

Currently i got a functional map which retrieves a record based on conditions complete & Standard

=f_mapStatus(In1, EXTRACT(field1:In1,field3:In1="complete" & field4="Standard"))

I need to retrieve two more records based on different conditions using same functional maps.
Extract function looks as follows.

**EXTRACT(field1:In1,field3:In1="xyz" & field4="qwe"))**
**EXTRACT(field1:In1,field3:In1="pqr" & field4="asd"))**

So how do i nest same functional map 3 times..Each time passing different conditions...

Any help appreciated..
Many thanks in advance
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Not sure if undersand the condition in which you want to "nest" the call, but you might try the use of EITHER function:

=f_mapStatus(In1,
EITHER(EXTRACT(field1:In1,field3:In1="complete" & field4="Standard"),
EITHER(EXTRACT(field1:In1,field3:In1="xyz" & field4="qwe"),
EXTRACT(field1:In1,field3:In1="pqr" & field4="asd"))))

You also have to be aware of the issue around "binding" when trying to perform multiple series consuming functions on the same rule with the same objects. The EITHER function help avoid this issue.

Hope this helps.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: pje77

You can also try this :

f_mapStatus(In1, EXTRACT(field1:In1,(field3:In1="complete" & field4="Standard")|(field1:In1,field3:In1="xyz" & field4="qwe")|(field1:In1,field3:In1="pqr" & field4="asd"))
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender