topic Re: TOS : in Tmap component from excel delimeter, how to get previous cell value in case of null values ? in Talend Studio

TOS : in Tmap component from excel delimeter, how to get previous cell value in case of null values ?

Anonymous — Mon, 23 Sep 2019 14:57:13 GMT

Hi all,

By using Tmap component, I transfer a table from excel file to a csv file with some transformations.

However, in my origin excl file, I have this case, in my first column i have some null values:

A | Value1 | Value 2

B | Value 3 | Value 4

| Value 5 | Value 6

C | Value 7 | Value 8

In my output file (csv file), i want to get :

A;Value1;Value 2

B;Value 3;Value 4

B;Value 5;Value 6

C;Value 7;Value 8

How to do ? Get previous row value in case of it's null

Thank you

TRF — Mon, 23 Sep 2019 15:14:26 GMT

tMemorizeRows component is what you are looking for.

You can also do the same with tMap local variables (a little bit more tricky).

Anonymous — Tue, 24 Sep 2019 09:25:40 GMT

thank you

TRF — Tue, 24 Sep 2019 10:39:54 GMT

You're welcome