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
Filtering the records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 19
- Joined: Sun Jun 29, 2008 10:19 pm
Filtering the records
Thanks and Regards
Arun
Known is a drop and Unknown is an Ocean
Arun
Known is a drop and Unknown is an Ocean
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.
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.
Rgds,
MB
MB