topic Re: How to recreate LastRowInGroup of Datastage in Talend? in Talend Studio

How to recreate LastRowInGroup of Datastage in Talend?

Anonymous — Thu, 05 Sep 2019 05:41:20 GMT

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.

Re: How to recreate LastRowInGroup of Datastage in Talend?

Anonymous — Mon, 23 Sep 2019 08:34:29 GMT

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

Re: How to recreate LastRowInGroup of Datastage in Talend?

Anonymous — Mon, 23 Sep 2019 09:31:51 GMT

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.