How do I shift values in columns?

Use special variables i or ii if your table is static and append-only. If your table is ticking, or not append-only, use updateBy with RollingGroup. Using i looks like:

Note

These FAQ pages contain answers to questions about Deephaven Community Core that our users have asked in our Community Slack. If you have a question that is not in our documentation, join our Community and we'll be happy to help!