Working with Tables
Quant has a large number of tables in which items can be easily filtered, sorted, reordered or searched. Many functions will make it easier for you to work in Quant. This manual describes what features Quant offers when working with tables.
In this manual, you will learn:
- How do you change the order of the columns?
- How can you sort items in a table according to a specific column?
- How can you filter in tables?
- How do you set up a table to see only the columns you need?
- How do you change the width of a column?
- How do you save a table configuration so you can use it again later?
- How do you search in tables?
- How can you add a table in the table to all the items that you have written in a particular file?
- How do you copy a value from a table?
- How can you export an entire spreadsheet from Quant to Excel or CSV?
- How do you build a contingency table?
- How you can display a graph for a table?
How do you change the order of the columns?
Simply drag the column behind the header by drag & drop to where you want to move it.
How can you sort items in a table according to a specific column?
Clicking in the column header (by which you want to sort the items) activates the sorting. The first click sorts numeric items from the lowest number to the highest or text from A to Z. The second click sorts from the highest value to the lowest for numeric attributes. For text attributes, it sorts from Z to A.
We recommend you to read the Sorting in Tables manual which describes more advanced tools for sorting.
How can you filter in tables?
If you move cursor over a column header, a filter symbol will appear. If you click on this symbol, you will be offered values by which you can filter. The filter also allows you to search, so you can start typing the value you're looking for. This value will then appear in the filter.
We want to filter only products from the supplier Slovepo in the table with products. The procedure is described in the figure below.
You can ream more about filter in the Filtering in Tables manual.
How do you set up a table to see only the columns you need?
Most tables in Quant are often too detailed and may contain columns that are not relevant to you. In any table, you can hide any column and keep only those that are important to you.
There are two ways you can proceed.
- You only need to hide one or a few columns - you can hide any column by right-clicking on its header and selecting Hide Column.
- You need to hide a lot of columns and leave only a few visible.
- Right-click in a column header.
- Choose Select Visible Columns.
- The attributes that are currently present in the table are displayed in a new window:
- Click the Add Above or Add Below button to add additional columns.
- If you mark an existing attribute in the window, you can remove it from the table by clicking the Remove button.
How do you change the width of a column?
For example, if you want to expand a column to see more text, just expand the column in the header. It is also possible to activate the function of automatic resizing of columns according to the length of the text for one or all columns in the table.
How do you save a table configuration so you can use it again later?
If you set up a table configuration that you would like to use in the future, you can save it to the Table Settings Browser. Here you can save several configurations and switch between them as needed.
You can read more about the table settings browser in the Table Setting Browser manual.
How do you search in tables?
Above each table is a search box where you can type the term you want to search by. Click on the magnifying glass icon to see more advanced search options.
In addition, there are several icons above the table that you can use:
- Mark visible - marks all visible items in the table (filtered by you).
- Unmark All- deselects all items in the table.
- Advanced selection - allows you to add to the selection all items that you have listed, for example, in a table in Excel or in a text document.
You can find a detailed description of this functionality in the Advanced Selection manual.
- Copy Marking - copies the marked products in the table
- Paste marking - pastes marking of products into the table
The above-mentioned two options are used when you have several products marked in one table and you want to mark the same products in another table.
In Quant, you can copy the content of any cell in the table to the clipboard by ALT+clicking into the cell whose content you want to copy. You can then paste the copied content anywhere using Ctrl (Cmd)+V.
How can you export an entire spreadsheet from Quant to Excel or CSV?
It is possible to export any table in Quant to Excel or to CSV using buttons in the left panel. The table will always be exported as you see it (applying filters and sorting, exporting only visible columns...).
How do you build a contingency table?
You can examine and analyze the data in any table in more detail in a contingency table.
How you can display a graph to a table?
You can also view a chart for any table in Quant, which allows you to analyze different tables.
For a more detailed description of the tool for charting tables, see the Table Chart manual.