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.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema