I would like to fill the null values in StoreName with the previous StoreName values. For example the first 7 products are based in the "AKHİSAR" store but the store name is valid for only the first row because of the Excel formatting.
Here is what i want to achieve:
I'm not sure if i can do this with Replace in String step.
And i'm using Pentaho 9.0 version.
Thanks in advance!
You can achieve this with the help of Modified JavaScript Value step in Pentaho. Below are the steps:
Drag and drop javascript step into your transformation and open the step.
Write a script as below:
if (StoreName != null){
var updateStoreName = StoreName;
}else{
CONTINUE_TRANSFORMATION
}
A sample gist is provided in here for reference.
If you are using the Javascript in compatibility mode, then you may have to change the variable assigned accordingly. More is available in the official documentation.