I have a certain value I need to replace with missing value. These are numeric columns and I want to replace -999 with missing value. Is there a way to do this generically, eg. without having to explicitly replace all the columns with a java snippet node and repeat the value dedection code as many times as there are columns? There are a lot of them.
Yes you can loop this. See the attached workflow.
Basically I remove the undesired cells in the row filter node and the loop end fills them up with missings.
It would also work with the java snippet. The main trick is to rename the column with the extract column header and afterwards use the insert column header to get the same column name again.
Ok. thank you.