topic Re: Pull data from previous row if fields are blank in Talend Studio

Pull data from previous row if fields are blank

Jj5 — Mon, 07 Dec 2020 18:40:00 GMT

Hello,

I have a task where I'm given data that I need to populate from a previous record with the same unique ID.

It looks something like this:

1000 ||||03/01/2020| 123 Market Hw

3000 | Justin T | ...

The first time a new ID shows up we should have all the data. For the subsequent rows we only have the new data, everything omitted is assumed to be repeating and I need to populate it from the previous row as long as the Customer ID matches to the current line.

My expected outcome from the use case is as follows:

3000 | ...

If there's a component that will allow me to do this with many fields I'd prefer that over java code using variables, I have around 30 fields that I'll need to utilize this solution for.

Re: Pull data from previous row if fields are blank

Anonymous — Tue, 08 Dec 2020 09:33:30 GMT

I think tMemorizeRow component can meet your need, please refer to the component documentation and learn this component. Here I show you an example on tMap.

data source input-main--tMemorizeRow_1---tMap....>

Regards

Shong

Re: Pull data from previous row if fields are blank

Anonymous — Tue, 08 Dec 2020 10:31:21 GMT

Hello,

As you have mentioned you want the solution without using custom code, you can do this in a tMap via if else expression.

https://community.talend.com/s/article/tMap-expression-syntax-TCiHW

Here is also a tMemorizeRows component which memorizes group key and columns on the previous row.

Best regards

Sabrina

Re: Pull data from previous row if fields are blank

Jj5 — Tue, 08 Dec 2020 15:00:03 GMT

Thanks @Shicong Hong and @Xiaodi Shi. I'm not sure how to mark the topic as resolved but that's the solution I was looking for