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

[Anonymous]

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 · Accepted solution]

tMemorizeRows component is what you are looking for.

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

[Anonymous]

thank you

[TRF]

You're welcome