How to set lag no.as variable to run loop in Lag column

[Chenfang]

Hi Knime experts
I have below part with difference lag request for demand.

I use table row to variable loop start to set lag no. as variable, but I don’t know what’s wrong, the workflow can get the result what I want.
Thanks for help in advance.

Below picture show my workflow result and what I want, hope it’s clear for understanding.

[lelloba]

Hi @Chenfang,

is something like this working for you?

Lagging with parameter – lelloba

Let me know,
RB

[Chenfang]

Hi Lelloba
Thank you so much for your prompt reply and perfect solution. It works.

[Chenfang]

Hi Lelloba
I have another question, if I want lag with negative, how to set up, thanks!

[lelloba]

In that case you have to use another node called Moving Aggregation.

See this post: Lag Column with Negative value? - #8 by Isabell

Alternative: this node

Lead – riznylafi

RB

[Chenfang]

OK, thanks, let me try.