Slice
Last updated
Was this helpful?
Last updated
Was this helpful?
Select rows by positions. This is not supported for relational databases, in which case you should use filter() with row_number() function.
Click "+" button and select "Other" - > "Slice(Select Rows)"
You can select rows by specifying start and end row position.
Start Row - Start Row position. for example, if you want to select rows from second row to fifth row, set 2 as Start Row.
End Row - End Row position. if you want to select from rows from second row to fifth row, set 5 as End Row. If you select from second row to last. You can set n() for End Row.
