topic Re: [resolved] Extract row with the maximum value in Talend Studio

[resolved] Extract row with the maximum value

izumisawaa — Sat, 16 Nov 2024 13:37:53 GMT

hello;
I have a file with 3 colums:
|category|name|upd_date(yyyymmdd)
|=--------+-----+-------=
|1 |foo |20091201
|1 |bar |20100101
|2 |hoge |20091215
category => Group by
upd_date => max(condition)
name => extract
I want to extract the name that has it with the newest upd_date (maximum value) each category(Group by ).
I want to get this result:
|category|name|upd_date
|=--------+-----+-------=
|1 |bar |20100101
|2 |hoge |20091215

Can you help me
Thank you.

Re: [resolved] Extract row with the maximum value

Anonymous — Fri, 25 Dec 2009 03:34:26 GMT

Hello guy
Here I show you an example,
in.csv:

1;foo;20091201
1;bar;20100101
2;hoge;20091215
2;shong;20091214

result:

Starting job forum9360 at 11:28 25/12/2009.
 connecting to socket on port 4283
 connected
.--+----+--------.
|   tLogRow_1    |
|=-+----+-------=|
|id|name|upd_date|
|=-+----+-------=|
|1 |bar |20100101|
|2 |hoge|20091215|
'--+----+--------'
 disconnected
Job forum9360 ended at 11:28 25/12/2009.

Best regards

shong

Re: [resolved] Extract row with the maximum value

izumisawaa — Fri, 25 Dec 2009 08:15:38 GMT

hi Shong
Thank you ;Problem resolved
😃
at tFileInputDelimited_2...
Should I sort (order by upd_date, id) it before the link of tMap(Lookup)?

Re: [resolved] Extract row with the maximum value

Anonymous — Fri, 25 Dec 2009 08:17:25 GMT

Hello

Should I sort (by upd_date) it before the link of Lookup?

No, it don't need.
Best regards

shong

Re: [resolved] Extract row with the maximum value

Anonymous — Fri, 22 May 2015 13:24:40 GMT

Where is the solution?
Got the same problem.

Re: [resolved] Extract row with the maximum value

Anonymous — Mon, 25 May 2015 03:47:26 GMT

Hi litttledirk
This topic was a little old, please report a new topic for your problem with details in order to manage and follow up your question more easier.
Thanks!
Shong

Re: [resolved] Extract row with the maximum value

Anonymous — Tue, 26 May 2015 07:12:39 GMT

My problem is exactly what you describe in post #2 (example and expected result).