I have some data that I would to format within knime. I would like to be able to add a column with data that changes everytime a certain phrase is recognized. In this case it is “Zeeco Inc.” Everytime this appears I would like for the generated column to be the word under “Zeeco inc” until another “Zeeco Inc” appears.
Below I have done this in excel. Can this be done in Knime?
so use Lag Column node on column containing “Zeeco inc” value. Follow it with Rule Engine node to write value from “Zeeco inc” column when there is “Zeeco inc” in new (lagged) column. Finish it with Missing Value node and option to write previous value. Give it a try and if questions/issues I can make you an example from provided data.