Skip to main content

DB_Table.drop

droprange

Group: Selections
Aliases: remove, skip

Documentation​

Creates a new Table from the input with the specified range of rows removed.

For the purposes of the Index_Sub_Range.While predicate a single "element" of the table is represented by the Row type.

Arguments​

  • range: The selection of rows from the table to remove.

Examples​

Drop first 10 rows of the table.​

      table.drop (..First 10)

Drop rows from the top of the table as long as their values sum to 10.​

      table.drop (While row-> row.to_vector.compute Statistic.Sum == 10)

Remarks​

Supported Range Types​

Database backends support all range types except While and Sample

In-memory tables support all range types.