Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[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
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

5 Replies
Anonymous
Not applicable
Author

Hi,
We often use tAggregateRow to do minimum or maximum operation.
Best regards
Sabrina
0683p000009MEKN.png
Anonymous
Not applicable
Author

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

Regards,
Kal
Anonymous
Not applicable
Author

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

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
Not applicable
Author

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/