October 30, 2009 at 9:10 am
I'm using a conditional split to send valid rows to one output file and invalid rows to a separate output. For the "invalid" output, I have multiple conditions on the same condition line. So it looks something like this:
LEN(Acct) == 0 || Dept != 46000 || ([Doc Type] != "CKC" && [Doc Type] != "INV" && [Doc Type] != "JV")
I want to be able to show all conditions that caused a particular row to be sent to the "Invalid" output. In other words, if a particular row was sent to the invalid output because the length of the Acct field was equal to 0 and the Dept value did not equal 46000, is there a way for me to show that in a separate column in the output file?
November 2, 2009 at 10:36 am
I continue to be unsuccessful in my search for a solution...any takers out there?
Thanks again!
November 2, 2009 at 11:00 am
You could add a Derived Column transformation that tests each of the conditions in your Conditional Split individually. Make each of the derived columns of type DT_BOOL.
Your first derived column's expression would be:
LEN(Acct) == 0 ? 1 : 0
Second derived column's expression would be:
Dept != 46000 ? 1 : 0
and so on.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply