topic Re: [resolved] How can I store the Last row in another table also in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 12:23:54 GMT

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.

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

Anonymous — Wed, 08 Feb 2012 15:21:51 GMT

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.

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

Anonymous — Thu, 09 Feb 2012 06:01:01 GMT

Thank you very much