Slice
Last updated
Last updated
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.