Page 1 of 1

in operator in Transformer

Posted: Wed Apr 27, 2011 9:34 am
by Nagac
Hi

I have a requirement to use IN operator in Constraints of Transformer.

Can we use this?

Eg:
ID In (1,2,3,4)

I could not find IN operator in Transformer.

Re: in operator in Transformer

Posted: Wed Apr 27, 2011 9:42 am
by MarkB
Nagac wrote:I could not find IN operator in Transformer.
That's because there isn't one ... a simple search here would show this topic discussed many times over. You can use the Index function to get the results you need.

Posted: Wed Apr 27, 2011 4:38 pm
by Nagac
Can you suggest how can we do this by using Index function?

Posted: Wed Apr 27, 2011 6:19 pm
by ray.wurlod
Is your Search function broken?

Assuming that the value being sought is a single character called TheCode then a suitable expression would be

Code: Select all

Index("1234", InLink.TheCode, 1)