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

[Anonymous]

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

[Anonymous · Accepted solution]

Hi,
We often use tAggregateRow to do minimum or maximum operation.
Best regards
Sabrina

[Anonymous]

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

Regards,
Kal

[Anonymous]

Hi,
It will be highly appreciated that sharing your solution with us.
Best regards
Sabrina

[Anonymous]

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?

[Anonymous]

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/