Keep only lines which has a max value column

[Alpha549]

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 · Accepted solution]

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

[Alpha549]

Hello @not specified not specified​ ,

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

Thank you !