Prep Tool

The Prep Tool is useful for preparing data (and then organizing the data into one or more tables).

Minitab Connect - patch.tmmlog.in - Google Chrome

Toolbar items:

Minitab Connect - patch.tmmlog.in - Google Chrome

1. Hide / Show

Minitab Connect - patch.tmmlog.in - Google Chrome

2. Reset Configuration

Minitab Connect - patch.tmmlog.in - Google Chrome

3. Save

Minitab Connect - patch.tmmlog.in - Google Chrome

4. Run

Minitab Connect - patch.tmmlog.in - Google Chrome

5. Auto Load

Minitab Connect - patch.tmmlog.in - Google Chrome

6. Add

Minitab Connect - patch.tmmlog.in - Google Chrome

7. Save As

Minitab Connect - patch.tmmlog.in - Google Chrome

8. Edit as Text

Minitab Connect - patch.tmmlog.in - Google Chrome

9. Delete

Minitab Connect - patch.tmmlog.in - Google Chrome

10. Export

Minitab Connect - patch.tmmlog.in - Google Chrome

11. Import

Minitab Connect - patch.tmmlog.in - Google Chrome

12. Save External

Minitab Connect - patch.tmmlog.in - Google Chrome

13. Export to Minitab

Minitab Connect - patch.tmmlog.in - Google Chrome

14. Conditional Formats

Minitab Connect - patch.tmmlog.in - Google Chrome

15. Mass Transform / Mass Format

Minitab Connect - patch.tmmlog.in - Google Chrome

16. Show Totals

Minitab Connect - patch.tmmlog.in - Google Chrome

17. Orientation

Minitab Connect - patch.tmmlog.in - Google Chrome

18. Show SQL

Minitab Connect - patch.tmmlog.in - Google Chrome

19. Clear Filter(s)

Minitab Connect - patch.tmmlog.in - Google Chrome

20. Read Only

Minitab Connect - patch.tmmlog.in - Google Chrome

Tab items:

There are four tabs available:

  1. Field(s) - Used to select options about the Field(s), the order displayed, the Format(s), and the various views of the data displayed in the Table.
  2. Filter(s) - Used to narrow down the data to fine tune what is displayed in the Table.
  3. Sort(s) - Used to select how the data gets organized in the column(s) of the Table.
  4. Save(s) - Used to Run, Edit, or Delete your saved Table(s), and revisit them as needed.
Minitab Connect - patch.tmmlog.in - Google Chrome

1. Field(s) Tab

Used to select options about the Field(s), the order displayed, the Format(s), and the various views of the data displayed in the Table.

  1. Add a Field to the view.
  2. Add all Fields to the view.
  3. Remove all Fields from the view.
  4. A Field in the view.
  5. Hide the visibility of a Field.
  6. Apply a Format to the Field.
  7. Apply a View to the Field.
  8. Remove Field.
Minitab Connect - patch.tmmlog.in - Google Chrome

Clicking the Run button will display the Field names in columns (with the data beneath them).

Minitab Connect - patch.tmmlog.in - Google Chrome
Minitab Connect - patch.tmmlog.in - Google Chrome
Minitab Connect - patch.tmmlog.in - Google Chrome

2. Filter(s) Tab

Used to narrow down the data (to fine-tune what is displayed in the Table).

  1. Filter on Original Data.
  2. Filter on Prepped Data.
  3. Add Filter Group(s).
  4. Add Filter.
  5. Or/And Toggle.
  6. Clear Filter(s).
Minitab Connect - patch.tmmlog.in - Google Chrome
Minitab Connect - patch.tmmlog.in - Google Chrome

3. Sort(s) Tab

Used to select how the data gets organized in the column(s) of the Table.

  1. Add a Field to Sort.
  2. Add Default Sort(s).
  3. Remove All Sort(s).
  4. A Sort.
  5. Move the order of a Sort.
  6. Ascending/Descending toggle.
  7. Delete Sort.
Minitab Connect - patch.tmmlog.in - Google Chrome

4. Save(s) Tab

Used to Run, Edit, or Delete your saved Table(s), and revisit them as needed.

  1. Search Saves.
  2. Show Default Save.
  3. Refresh Save(s).
  4. A Saved View.
  5. Run a Saved View.
  6. Edit a Saved View.
  7. Delete View.
Minitab Connect - patch.tmmlog.in - Google Chrome