Remove Rows from a Project

Use

Use this article to remove rows of data from your Project.



Overview

As you prepare your data, you will find times when you want to retain a specific subset of data. The best way to accomplish this is to remove the rows of data that don’t meet your needs. The following is an overview of the elements you work with when you remove rows from your Project.



ElementDescription
Data Preview

The data in your Project, you will see your data change as you prepare it.

Filtergram™Filters your data down to a subset that you want to isolate. See the Data Filtergrams article.
Remove ToolThe tool that removes rows from your Project.



Remove rows from your Project

Follow these steps to remove rows of data from your Project.

StepAction
1

Add a Filtergram to isolate the rows you want to remove. See the Data Filtergrams article.

Result: The Data Preview displays the records that match the criteria of your filter.

2

From Tools, click Remove.

Result: The Filters on the Current Dataset panel becomes the Filters for Remove Rows panel.

3

Click Save.

Result: The filtered rows are removed. The Data Preview is blank because the filter used is still active and the data has been removed.

4

To display your updated dataset, do one of the following:

  • On the Filtergram, click x clear.
  • Close the Filtergram.

Result: The Filtergram is cleared. The Data Preview displays the updated data.

Pax Pro Tip: Publish the data from the removed rows to a separate AnswerSet for later reference. See the next section for details.

Note: If you update or add to your dataset after the removing rows, the remove rows Step will be applied to the new data in the following ways:
1. If you selected histogram ranges or individual values to remove rows, rows from the new data will only be removed if they satisfy that exact condition.
2. If you selected rows with a string search or dynamic percentile range, then the tool will recompute based on the new data.


Capture data from rows you’ve removed

Follow these steps to add a Lens to publish the rows you removed.

StepAction
1

From Tools, click Steps.

Result: The Steps panel appears.

2

Click the step prior to the Remove Rows step.

Result: The Data Preview displays all rows, including the ones that existed prior to applying the Remove tool.

3

Add a Filtergram to isolate the rows you removed. See the Data Filtergrams article.

Result: The Data Preview displays the records that match the criteria of your filter.

4From Tools, click Lens > New Lens. See the Project Lenses article.
5

Click Save.

Result: The Lens is added to the Project.

6

Publish the Lens.

To publish ...Then ...
NowFrom the Lens, click Publish.



Glossary

The following definitions for terms used in this document.

TermDefinition
AnswerSetLike a dataset except that it is the published result of your data prep.
Base datasetThe data on which all other actions in the Project will be performed.
Data sourceThe source of your dataset.
DatasetData that is imported into the Data Library is called a dataset.
FiltergramThe combination of the functionality of filters with the power of histograms.