Update previous rows in tMap or tJava

[ldao1595437021]

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

[Ravi_Rajagopal]

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.

[ldao1595437021]

Could you give me detailed instructions

[David_Beaty]

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