how to fetch last row record
how to fetch last row record
how to fetch the last row of a particular column? what should be used? transformer or aggregator???
Re: how to fetch last row record
ssharmila wrote:how to fetch the last row of a particular column? what should be used? transformer or aggregator???
Well.....One way can be to use a transformer stage and generate a new column which will be made to store numbers in increasing order.i.e the column values will act as a row number.Then we can use an aggregator and pull the record with max row number.
I am not sure....how efficient this method is....
If anyone gets a better method please suggest.
Regards
hari4dsx
Hari