topic Re: Filtering Getting the newest row in Talend Studio

Filtering Getting the newest row

MarcusDidius — Fri, 15 Nov 2024 23:37:54 GMT

I have the following problem:

I have a data table with several entries for each serial number and I need only the one entry with the latest timestamp for each serial number. I have no idea how to do this in talend.

Re: Filtering Getting the newest row

Anonymous — Wed, 13 Oct 2021 09:15:06 GMT

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

Re: Filtering Getting the newest row

Anonymous — Wed, 13 Oct 2021 17:52:36 GMT

I suggest doing this with SQL. I would use a rank over partition function.

select

id,

name,

whatever,

rank() over (partition by id order by my_timestamp desc) as ranking

from my_table

the ranking column will contain 1 (or 0 - you need to check that) for the record with the newest timestamp.

Please take it as suggestion, the window functions have different syntax for different database products.