DSXchange

Hi,

Is there any function available in DS equivalent to Oracle IN or NOTIN functions?

I need to implement below logic in my job.
If the column PRODUCT value is IN ('AA','BB','CC','DD','EE','FF'), then the output is 1 else 0.can you please suggest any ideas?

Thanks & Regards,
Veera.

That would be the Index() function, something you can search for as its use for this purpose has been documented here quite a bit.

Even You can use 'If Then Else' in Transformer and get the result.

True... but that would be more of an alternative rather than an equivalent.