[resolved] how to get min or max from a list of value

One Star

[resolved] how to get min or max from a list of value

Hi All,
I just wonder, how talend can return me the minimum or maximum value of a list of values. See example below:
Value List
----------
2005
2006
2007
2008
2009
Expected Output
-----------------
Min Value = 2005
Max Value = 2009
Your help is greatly appreciated.
Regards,
Kal

Accepted Solutions
Moderator

Re: [resolved] how to get min or max from a list of value

Hi,
We often use tAggregateRow to do minimum or maximum operation.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

Re: [resolved] how to get min or max from a list of value

Hi,
We often use tAggregateRow to do minimum or maximum operation.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] how to get min or max from a list of value

Hi Sabrina,
Thanks for the solution provided. I noticed that Smiley Happy

Regards,
Kal
Moderator

Re: [resolved] how to get min or max from a list of value

Hi,
It will be highly appreciated that sharing your solution with us.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] how to get min or max from a list of value

hi,
i have a job which runs periodically, and every time it needs to insert new records. max id is fetched using taggregaterow. problem is first time it gives proper max value but after inserting new records, old max id reappears.
my flow to get max id is:
tmdminput ---> taggregaterow ---> tjavarow
i am setting context variable with max id

can u please help me out?
Four Stars

Re: [resolved] how to get min or max from a list of value

HI Rishi

Hope you have set the incremental id at the MDM level for every new record you have inserted into MDM. If so test please check whether it is generating Incremental id for every new record.




thanks
Anil Kumar Burri
http://anilkumarburri.wordpress.com/