How to delete specific rows
In Table recipe, you cannot manually select one or more rows and delete them with a function. However, it is still possible to target specific rows using filters, and use the Delete filtered rows function.
Let's say that you are using a file with 600 rows as source for your recipe, and you want to delete the first 100 rows of your table:
-
From the functions list in the left panel, select the Create new column function in the Columns category.
-
Choose a column name and an anchor position.
-
In the Fill column with drop down list, select Sequence.
-
Select 1 as Start value,1 as Step value and click Apply.
A new column containing a sequence from 1 to the last row number is created.
You need this sequence so that the filter you are going to use is based on fresh new consistent values, and not the content of other columns.
-
Select the header of the column containing the sequence and click the Filter button.
-
Select is lower than or equals as operator, enter 100 as value and click Apply.
-
The filter is applied and only the first 100 rows of the dataset are displayed in the grid.
In order to target the last 100 rows, you could have selected the is greater than operator with 500 as value for example.
-
From the functions list in the left panel, select the Delete filtered rows function in the General category and click Apply.
All the rows you have targeted with your filter have been deleted and you can now remove the sequence column if you want.
This example was about removing the N first or last rows of your table, but more generally you can build any combination of filters to target and delete the rows that you want.