I want to repeat the content in the first column into the same column of the next row when these column is empty and so on. Example:
I want the text “Normal” in row 1 column1 also in column1 in the rows 2, 3 and 4. The text “Extra” also in row 6 and so on.
The Missing Value Node doesn’t work with the warning: The current settings use missing value handling methods that cannot be represented in PMML 4.2
Has anyone an idea how to solve my problem?
Have a look at the below topic, another user posted the exact same question:
I wanted your help to copy the highlighted data in fig:1 to the fields in the below which are blank.
Fig :1 Data :
I tried lag column but the blanks following the data could be any number, it need not be always 2 or 3 blanks cells following it
Note: Date may or may not be same for each Online Customer, but Vch No. is always unique for each Online customer
Make sure your missing values are actually
null and not “”.
Then the Missing Value node definitely works
Hope this helps!
thanks for your fast reply.
But unfortunately it doesn’t work. I don’t get the content to null so that I have the “?” in the column.
How can I change that?
It’s almost inpossible to troubleshoot without having an example. Can you upload a (anonymized) sample from your actual source similar to what you have used in your first post? A workflow with the data preloaded also works.
Usually a RegexPlace of
[^0-9a-zA-Z+-.,!@#$%&*()^:;\/|<>"'_] or similar should be sufficient to get it to null.
I did the following and now it works.
In the String Manipulation I used the expression:
And now the Missing Value Node works proper.
Thanks for your help.