Hi all, I’m new in Knime, i was using SPSS Modeler but now i need to transform my flow to Knime. In SPSS Modeler, there is a useful function(@OFFSET) to take lag and update old value and calculate again. For example; there is a column named x(volume) and its values are 1, 0, 3, 0, 0, 0 and i want to create y(how many days have no sales) column as; 0,1,0,1,2,3. It means if x>0 y=0; else y starts with 1 and increases +1 while x=0 Notes: I have millions of data and don’t want to use python because it is very slow owing to taking data on its platform. Also, i don’t want to use loop in Knime because i have 6000 partition(like stores) and lots of date. Please help urgently

Hi @yunusEG and welcome to the KNIME community forum, I have built a workflow which is almost similar to the solution by @Fabien_Couprie but a bit shorter. offset.knwf (53.9 KB) No loops and no code. :blush:

OFFSET in Knime

KNIME Analytics Platform

yunusEG September 25, 2019, 8:16am 11

updated topic is below;

Thanks everybody

1 Like