Navigation: Reference > Transforms >
Keep or remove a continuous section of rows.
To keep only the records between the YEAR rows in this data:
Keep the slice from the first YEAR row to the next YEAR row and don't include the 'From' and 'To' rows:
•Set Mode depending on whether you want to keep or remove the slice.
•Set From according to how you want to choose the first row of the slice.
•Set Column, Matches and Value to match the first row.
•Uncheck Include 'From' row if you don't want to include the first row in the slice.
•Set To according to how you want to choose the last row of the slice.
•Set Column, Matches and Value to match the last row.
•Uncheck Include 'To' row if you don't want to include the last row in the slice.
•Number, date and text values are treated differently for Equal to, Greater than, Less than, Greater than equal, Less than equal and Not equal to operations. Any values that can be converted to a number will be treated as a number. Any values that match the supported date formats in Preferences will be treated as a date.
•All values are treated as text for Contains, Starts with, Ends with, Matches regex, Is not, Doesn't start with, Doesn't end with and Doesn't match regex operations.
•Comparisons of text are case and whitespace sensitive. You can use Case to change the case, Whitespace to remove whitespace before filtering and Replace to get of other unwanted characters (e.g. whitespace inside the text).
•See here for more details on Regular expressions (regex).