Icon

JKIKN-03

JKIKN Challenge 03
Challenge 3 - Days With Price ChangesYou are using KNIME to monitor the daily price of a product online. After using the Line Plot node to visualize the daily prices you have already gathered, you notice that they are often constant for a certain number of days before changing again. You want to create a new column in the price data you have at hand, named "Change", such that its value is 1 if a daily price changed with respect to the previous day, or 0 if it remained unchanged. For the first daily price in the data, the "Change" value should be 1.
read daily prices dataset
CSV Reader
date ascending
Sorter
add lag column
Lag Column
Rule Engine
remove price(-1)
Column Filter
include only change "1"
Row Filter

Nodes

Extensions

Links