Pick Up only last row...
Moderators: chulett, rschirm, roy
Pick Up only last row...
I have 3 output link in one transformer stage. In one link I want to take only the last row. I need to ignore all other rows. Is there any way to exclude all rows except the last row using constraint or any other method.....
Via a constraint? No, there really isn't a mechanism to recognize the 'last' row... unless you make sure it is something recognizable by adding a dummy/trailer record of your own, for instance.
A couple of other approaches. Can you sort the data so that the row you want comes first instead of last? Then a simple constraint can help you out. Something else to do is use the Aggregator to get the LAST value for the fields you are interested in. Also, if there is some way for you to count the records before the job starts, then pass in the record number of the last row as a parameter and constrain for it...
A couple of other approaches. Can you sort the data so that the row you want comes first instead of last? Then a simple constraint can help you out. Something else to do is use the Aggregator to get the LAST value for the fields you are interested in. Also, if there is some way for you to count the records before the job starts, then pass in the record number of the last row as a parameter and constrain for it...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 90
- Joined: Mon Dec 08, 2003 4:48 am
- Location: Chennai