Replace placeholder with values from above?

Hello,
I have a problem with my data.
The column “values” contains names e.g. aa1, aa2 etc.
Between the names there is always the same placeholder e.g. “dummy”.
I have to replace the placeholder with the name from above, see img:

image

How is that possible in KNIME?
Greetings

Hi @Tim8200

See this wf replace_placeholder.knwf (17.5 KB) . First it makes your Placeholder (dummy) missing. Then the missing values are replaced by the previois value.
Schermafdruk van 2022-01-06 10-23-37
gr. Hans

3 Likes

this was very easy :rofl:
thanks…

1 Like

@Tim8200 you can also do the replacement only for a specific column

@HansS nice solution with the implicit creation of a missing value in the Rule Engine :slight_smile:

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.