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
Multiple of contraints condition in Transformer
Moderators: chulett, rschirm, roy
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:
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.
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)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers