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

Toolbar items:

1. Hide / Show

2. Reset Configuration

3. Save

4. Run

5. Auto Load

6. Add

7. Save As

8. Edit as Text

9. Delete

10. Export

11. Import

12. Save External

13. Export to Minitab

14. Conditional Formats

15. Mass Transform / Mass Format

16. Show Totals

17. Orientation

18. Show SQL

19. Clear Filter(s)

20. Read Only

Tab items:
There are four tabs available:
- 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.
- Filter(s) - Used to narrow down the data to fine tune what is displayed in the Table.
- Sort(s) - Used to select how the data gets organized in the column(s) of the Table.
- Save(s) - Used to Run, Edit, or Delete your saved Table(s), and revisit them as needed.

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.
- Add a Field to the view.
- Add all Fields to the view.
- Remove all Fields from the view.
- A Field in the view.
- Hide the visibility of a Field.
- Apply a Format to the Field.
- Apply a View to the Field.
- Remove Field.

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



2. Filter(s) Tab
Used to narrow down the data (to fine-tune what is displayed in the Table).
- Filter on Original Data.
- Filter on Prepped Data.
- Add Filter Group(s).
- Add Filter.
- Or/And Toggle.
- Clear Filter(s).


3. Sort(s) Tab
Used to select how the data gets organized in the column(s) of the Table.
- Add a Field to Sort.
- Add Default Sort(s).
- Remove All Sort(s).
- A Sort.
- Move the order of a Sort.
- Ascending/Descending toggle.
- Delete Sort.

4. Save(s) Tab
Used to Run, Edit, or Delete your saved Table(s), and revisit them as needed.
- Search Saves.
- Show Default Save.
- Refresh Save(s).
- A Saved View.
- Run a Saved View.
- Edit a Saved View.
- Delete View.
