Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to recreate LastRowInGroup of Datastage in Talend?

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.

Labels (2)
2 Replies
Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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. 0683p000009MACn.png

 

Thanks.