Hi, I would like to follow up on someones’post from 3 years ago which found extremely useful. Does anyone knows how to produce two directional lag columns?
“The “premium version” would be able to produce both directions at the same time, allowing the user to choose which copy to use as the base. This version wouldn’t necessarily need negative intervals, of course.”
extract the Row id of your table with the RowID Node
use the Lag Column Node on the extracted ids (introduce the lag you need)
Join the new table with lagged ids back to your original table on the unaltered RowIDs (use Left or Right Outer Join as desired).
I think the resulting table would be like a negative lag. You can use Quickforms to parameterize some of the nodes, so you can encapsulate it in a reusable metanode.
Could that help you?