topic Re: Update previous rows in tMap or tJava in Talend Studio

Update previous rows in tMap or tJava

ldao1595437021 — Sat, 16 Nov 2024 01:49:27 GMT

Hi All,

I need one help to build below logic, we can use tMap or tJava.

My input and output is text file.

I want to populate Missing data using same value as first available value as per below screenshot.

Thanks,

LucDK

Re: Update previous rows in tMap or tJava

Ravi_Rajagopal — Wed, 22 Jul 2020 22:49:04 GMT

tMap should be able to help you out with the same. You can add variables to do a translation as in if the source is null as is the case indicated with red fields, you can populate the same with default values and the component will take care of the same. There are YouTube videos available which will walk through exactly how to do this.

Re: Update previous rows in tMap or tJava

ldao1595437021 — Thu, 23 Jul 2020 01:21:27 GMT

Could you give me detailed instructions

Re: Update previous rows in tMap or tJava

David_Beaty — Fri, 24 Jul 2020 15:56:00 GMT

Hi,

Theres a component in Talend for doing just this, called tMemorizeRows, or you can do it in a tJavaRow, but putting the current row value for a given column into a globalMap variable if present, or getting the value from the globalMap if the value is missing.

Thanks

David