Filtering the records

arunkumar1111 · Post by **arunkumar1111** » Thu Oct 30, 2008 12:54 am

Hi All,

I have a scenario the pull out the records in folllowing order.

For a particular student there will be many records. there is a code column. if the code is 1 pull put all the 1 records, else if code is 2 pull out all the 2 records else pull out all the 3 records

Please can anyone help me with the logic

mdbatra · Post by **mdbatra** » Thu Oct 30, 2008 1:18 am

Are u simply looking for separating the records with code '1' in an output & code '2' in another or all in a single output?

If require diiferent ouput,make constraints either in transformer or Filter(preferably filter) & direct different constraints to different o/p.

If require single output, u can use Boolean expression(again using filter/transformer) & direct all the records satisfying the expression to a single o/p.