Foundation Documentation and SupportUser The Prep ToolHow do I limit my Data by Limiting the List?

How do I limit my Data by Limiting the List?

Click on the header (to open the Header Menu).

For this example, we are using the Location field.

Minitab Connect - patch.tmmlog.in - Google Chrome

Notice: Before the limit is applied, there are 6,488 records.

Minitab Connect - patch.tmmlog.in - Google Chrome

Select Limit List from the options.

Minitab Connect - patch.tmmlog.in - Google Chrome

Select the values you want to limit by.

If the column has a large selection of values, then this will be a searchable drop-down.

Minitab Connect - patch.tmmlog.in - Google Chrome
  1. By typing the wanted value in the Search box, any matching values will be displayed (we used Fort Fun for this example).
  2. Click the check box to add the value.
Minitab Connect - patch.tmmlog.in - Google Chrome

When completed, click the Limit button.

Minitab Connect - patch.tmmlog.in - Google Chrome

Congratulations, the Table is now Limiting the List by the value(s) you selected.

Minitab Connect - patch.tmmlog.in - Google Chrome

Also, notice that there are only 2,148 records now (instead of the 6,488 before we applied a Limit to the List).

Minitab Connect - patch.tmmlog.in - Google Chrome