Originally posted by: SystemAdmin

Has anyone seen this before, while using the MEMBER() function this doesn't work when I use the curly braces but does when I remove them?

=IF(MEMBER(Field:Group,{"ATXF"}), "Y","N")
Returns "N"

=IF(MEMBER(Field:Group,"ATXF"), "Y","N")
Returns "Y"
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: janhess

Your rule doesn't look right in either case.
It should be MEMBER ( single-object-expression, { literal, literal } )
So your rule should be
=IF(MEMBER(Field:Group,{"ATXF","Y","N"})
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

No it is right, I want to return "Y" if it is a member of and "N" if it isn't, here's the example from the help which means is EntityIDCode:Name a member of"BT" or "ST"

MEMBER (EntityIDCode:Name, {"BT" , "ST"})

#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: janhess

Which is what I said. The confusion seems to be over what "ATXF" is. Is it a member of the series or what you're trying to find in the series?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

That isn't what you said, your code said
=IF(MEMBER(Field:Group,{"ATXF","Y","N"})

which checks to see if Field:Group is one of ATXF, Y, N and I want if series is ATFX then return Y else return N
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: janhess

in that case you don't want to use member.

=IF (Field:Group ="ATXF","Y","N")
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Sorry for confusion but I do as that was a cut down example, I need to check more than one item
e.g.
=IF(MEMBER(Field:Group,{"ATXF", "ATXO", "ATXB"}), "Y","N")
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: janhess

That should work. What version are you using?
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

I know it should, thats why its strange that when I just used one value without curly brackets it did work, but with it doesn't

V8.1.0.1
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: janhess

It works fine at 6.7.1 and 8.1.0.2. Must be a bug at 8.1.0.1. Try raising it with support or upgrade to 8.1.0.2
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: jvanboga

Had the same problem in 6.5. Never bothered to question it much as it worked and continued to work in 6.7. Always assumed it was based on the way the element in the tree was defined.

(Sorry, is that lazy or what?)
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: DianeC

I use that function & it works. Here's something to try that sounds stupid, but I had to do this to get the function to take more than 9 values inside the curly braces - shut down Map Designer, then reopen. I had to go as far as waiting until the next day - as if a reboot cleared something that had the map designer 'stuck'. I know - you shouldn't have to do that, but if it works....
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender