Create a conditional column with rule regarding to cell value

KNIME Analytics Platform
#1

Dears,
I’m looking for a node that can create a conditional column with rule { if order id value changed return a text and the same for user name column, thanks in advance guys.

Data example:

order id user name
55555 username1
55555 username1
55555 username1
55556 username2
55556 username2
55556 username2
55558 username2
55558 username2
55558 username2
55558 username3
55558 username3

Amr

#2

You could take a look at the LAG Column node and combine it with a Rule engine.

https://www.knime.com/blog/all-you-need-is-the-lag-column-node

#3

Thanks @mlauber71 for your reply