topic Re: Keep only lines which has a max value column in Talend Studio

Keep only lines which has a max value column

Alpha549 — Fri, 15 Nov 2024 22:51:32 GMT

Hello everyone,

I have a question. Let's imagine that we're reading a CSV file.

Here is an example of data inside :

Col1 Col2 Col3

A 0 X

B 0 X

A 1 X

I would like, for each element (Col1), to keep only the line, which Col2 is max, so here, get this :

Col1 Col2 Col3

B 0 X

A 1 X

Reading from a database, it's simple using sub-queries, but what about reading from a CSV file.

How would you do this ?

Thank you 🙂

InfoCraft — Sun, 05 Jun 2022 08:52:30 GMT

Group by col1 than select max col2 using tAggregate...

Alpha549 — Sun, 12 Jun 2022 21:27:40 GMT

Hello @not specified not specified ,

Late answer ! It's exactly what I wanted to get.

Thank you !