Multiple of contraints condition in Transformer

Perwezakh · Post by **Perwezakh** » Tue Aug 11, 2009 1:17 pm

Hi guys,
I have a condition and trying hard to make it work. Need hint.
I have two columns Col1 and Col2. And these two columns I have required flags (these flag will tell me for which client these two data columns are required or not). Now in tranformer constraint I have to reject the record, IF Require_Flag for Col1 = "Y" and DataType of Col1 is Good Then Pass the data to good link Else Reject the record. AND Same logic for Col2.
I am unable to put multiple of IF conditions into contraints.
Help will be appreciated
Thanks

chulett · Post by **chulett** » Tue Aug 11, 2009 1:26 pm

You don't need "IF" statements in a constraint, just expressions that evaluate to true or false. So, ignoring the part where we don't know what "is good" means, at a high level you would use this in the constraint:

Code: Select all

(Require_Flag for Col1 = "Y" and DataType of Col1 is Good) or (Require_Flag for Col2 = "Y" and DataType of Col2 is Good)

Something like that (perhaps with 'or' not 'and') would be the constraint on the keep link and you can either mark the reject link as a Reject or simply Not() the entire previous expression.