Hello, I am pretty new to Talend. Is there a way in which I can check for last row of the group after the table is sorted on the basis of a particular column name.
I want to replicate the same in Talend in a tMap or maybe using a routine in Java.
If we understand your requirement very well, you could use the Talend routine TalendDate with a methof of compareDate().
Let us know if it is what you are looking for.
Thanks for writing back. I am not sure how I am going to use Talends date comparing function to know if the row that is being processed by the tMap is the last one of a group. Please refer to the link that I had provided in my question to know what Datastages' LastRowInGroup method does exactly. And if you/community believes it can be done using some inbuilt function in Talend, please let me know with an example. That would be really helpful.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables