roll left for filters

Roll record or table columns left.

Signature

> roll left {flags}

Flags

  • --by, -b {int}: Number of columns to roll
  • --cells-only, -c: rotates columns leaving headers fixed

Input/output types:

input output
record record
table table

Examples

Rolls columns of a record to the left

> {a:1 b:2 c:3} | roll left
╭───┬───╮
│ b │ 2 │
│ c │ 3 │
│ a │ 1 │
╰───┴───╯

Rolls columns of a table to the left

> [[a b c]; [1 2 3] [4 5 6]] | roll left
╭───┬───┬───┬───╮
│ # │ b │ c │ a │
├───┼───┼───┼───┤
│ 0 │ 2 │ 3 │ 1 │
│ 1 │ 5 │ 6 │ 4 │
╰───┴───┴───┴───╯

Rolls columns to the left without changing column names

> [[a b c]; [1 2 3] [4 5 6]] | roll left --cells-only
╭───┬───┬───┬───╮
│ # │ a │ b │ c │
├───┼───┼───┼───┤
│ 0 │ 2 │ 3 │ 1 │
│ 1 │ 5 │ 6 │ 4 │
╰───┴───┴───┴───╯

Tips: Command roll left was not included in the official binaries by default, you have to build it with --features=extra flag