Originally posted by: SystemAdmin

In TX 7.5.1 I have a map rule like this:

IF(
MEMBER("TEXT", EXTRACT(value, key="MATCH")),
...
)

The problem is the MEMBER only seems to find "TEXT" in the first record returned by the EXTRACT.

Thanks all.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Sounds like it is doing what your wrote. Try sending data to a functional map with this rule inside.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Try swapping your fields around... assuming you want to check whether the EXTRACT returns a value of "TEXT".

e.g.

IF(
MEMBER(EXTRACT(value, key="MATCH"), {"TEXT"}),
...
)
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

MEMBER (single-object-expression, series-object-expression)
The first argument to MEMBER must be a single-object-expression, so EXTRACT will not work I think.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

I think this is what you are looking for:

code:1:c63c174a6b=EXTRACT(
series-object-expression
,MEMBER (
single-object-expression
,series-object-expression
)
)[/code:1:c63c174a6b]

Or a real mockup example might look like this:

code:1:c63c174a6b=EXTRACT(
Record Groups:Input_File
,MEMBER (
ID Fields:Record Groups:Input_File
,{"ID1","ID2","ID3"}
)
)[/code:1:c63c174a6b]
Put this in a series object formula field and it should do what you are wanting. If you are wanting further processing of the extracted object, you will need to call a functional map and pass it the extracted series object.

Hope this helps,
John M Gibby
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange