Hi Guys,

I have a weird problem with "filter rows" utility in sub transformation. In my sub-trans I have a simple condition and the true out put go to a sort step and then a group by. The false output go to another sort step and then another group by.

The problem is when I have zero rows in false step the sort still get executed and then group by. When it reaches the group by it says it cannot find the group by field in the input set. I really dont know why.

I tried lots of variations of this and didn't get a solution. I created a sample transformation to replicate this and attached here. May be I am doing something silly.

folks, can you have a look? Appreciated your help

filter_rows_in_sub_trans_testing.zip

thanks
manoj