Hi,
I have an Excel reader and one column of the Excel files contains merged cells.
For an unknown reason, the option "expand merged cells" doesn't work well for some merged cells.
For some merged cells, I got all values in the expanded cells and for some others, I got only 2 values for 5 cells that were merged (for example).
(I tried to convert the Excel file in XLSX, XLS,.... the problem persists)
So, I try to find a solution to fill empty values with previous values from the same column (attribute).
I searched with the NullAttributeReplacer transformer or with a NullAttributeMapper but I don't find how to map to the previous value with this way...
One other difficulty is that it must work in "cascade": for example the empty value from row 3 must get the value from row 2 and then the empty value from row 4 must get the value from row 3, and so on...
Thanks for any help.
Christian