[resolved] How can I store the Last row in another table also

[Anonymous]

Hi All,

I am selecting data from a table.
and while doing transformation, I need to store "last row" data in another table also.

Can any one help me in finding out the last row?

Thanks in Advance.

[Anonymous · Accepted solution]

Hi,
You can try to do this with Numeric.Sequence but it's quite complex.
1. you create a file which contains a numeric sequence, this file has to be sorted by desc. You also add this sequence on your source table, no need to add it in your database, just use a tBufferOuput or a temporory file which contains each row+numsequence.
2. Make a innerjoin based on their sequence. The tFileInput should have a limit to 1, so it will only read the 1st line, ie the highter sequence number.

[Anonymous]

Thank you very much