Column Data Based On Row Change

All,

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?

LABOR TEST210000.xls (78 KB)

Hello @rparr009,

I have taken a look at your data. Is A column an output of what you would like to do in KNIME?

Br,
Ivan

Hi Ipazin,

Yes! That is correct!

Hello @rparr009,

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.

Br,
Ivan

1 Like

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