in operator in Transformer

Nagac · Post by **Nagac** » Wed Apr 27, 2011 9:34 am

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.

MarkB · Post by **MarkB** » Wed Apr 27, 2011 9:42 am

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.

Nagac · Post by **Nagac** » Wed Apr 27, 2011 4:38 pm

Can you suggest how can we do this by using Index function?

ray.wurlod · Post by **ray.wurlod** » Wed Apr 27, 2011 6:19 pm

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)

DSXchange

in operator in Transformer

in operator in Transformer

Re: in operator in Transformer