Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Refer here for LastRowInGroup function in Datastage.
I want to replicate the same in Talend in a tMap or maybe using a routine in Java.
Hello,
If we understand your requirement very well, you could use the Talend routine TalendDate with a methof of compareDate().
https://help.talend.com/reader/yyWN3FfPMuKdLZZ0B3WN7A/zCycGxbPtOHJylzqjyVutQ
Let us know if it is what you are looking for.
Best regards
Sabrina
Hello,
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.
Thanks.