topic Re: max and min in Talend Studio

max and min

Anonymous — Mon, 10 Dec 2018 10:04:24 GMT

without using taggregaterow how can i perform max and min operations in talend please provide a sample job

Re: max and min

Anonymous — Mon, 10 Dec 2018 10:27:26 GMT

Hi Ram,

It depends on your scenario. For example, you can do the aggregation in Database itself before bringing to Talend if the source is a DB.

If it is a sequence number, you can pick the last row's value will since it will be in ordered format.

If it is in jumbled format, you will have to sort the entire record set using tSortrow and then pick the value of last record by assigning the value of each row to a context variable using tjavarow . Since the previous value will be overwritten when new row is processed, automatically you will get the last row's value once the entire data set is processed.

I would suggest you to create a sample flow with the logic explained below to practice your learning. Could you please mark the topic as resolved since query has been answered? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: max and min

Anonymous — Tue, 11 Dec 2018 06:56:19 GMT

@rchinta

Could you please mark the topic as answered if the details given is fine for you?

Warm Regards,

Nikhil Thampi

Re: max and min

Anonymous — Thu, 13 Dec 2018 09:44:27 GMT

please provide an example data with job please

Re: max and min

Anonymous — Thu, 13 Dec 2018 09:52:03 GMT

Hi Ram,

Since I do not have the input values, why dont you setup a sample job based on the above instructions? If you are stuck somewhere, please feel free to contact Talend community and we will help you from there.

Warm Regards,

Nikhil Thampi