June 8, 2017 at 10:08 pm
i am checking 2 columns, column A != column B
and i am getting all records from file although both records has '@@ '
now i am replacing this with empty space and checking in my condition split column A != column B
still i am getting all the rows, what i am doing wrong here, i should not get any row.
June 9, 2017 at 9:43 am
I assume you are using the Conditional Split Transform. In which case, based on your logic, you should get 2 outputs. I will assume your test has the default Output Name of Case 1 so your outputs would be:
Case 1
Conditional Split Default Output
So any rows where column A does not equal column B will be sent to output Case 1, the remaining rows will be sent to Conditional Split Default Output. In your post you state that both have '@@ ' which make them equal so all rows where column A = '@@ ' and column B = '@@ ' will be sent to Conditional Split Default Output.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply