> ## Documentation Index
> Fetch the complete documentation index at: https://docs.flexagon.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Working with the Data Table

> About the Data Table The data table comes with a number of different features to help you view the data however you see fit. This page will cover ever

## About the Data Table

The data table comes with a number of different features to help you view the data however you see fit. This page will cover everything from applying filters and sort criteria to changing column and row sizes.

An outline of the table and its features can be seen below.

![image-20240603-214204.png](https://mintcdn.com/flexagon-llc-ce77a95c/NkeZh5D-Nf8j_WaD/images/fd111/12590922648.png?fit=max\&auto=format\&n=NkeZh5D-Nf8j_WaD\&q=85\&s=4851c70670920c0287ce9ce1b96cbdad)

1. **Add Filter** - By clicking on the filter icon on each column you can apply a specific filter to that column.

2. **Add Sort** - By clicking on the column header it will apply an ascending sort. Click again to apply a descending sort. Finally click again to remove the sort.

3. **Applied Filters and Sort** - Provides a quick look into what filters and sorts are currently applied to the table. 

4. **Saved Query Selection** - Add and select your [Saved Queries](https://docs.flexagon.com/flexdeploy-11-1-documentation/flexdeploy-users-guide/user-profile/saved-queries.md) for this table.

5. **Manage Columns** - Opens a sidenav where you can add/remove columns and re-order them.

6. **Additional Options** - Any additional options for controlling the table will show up here.

   1. **Dense** - Reduces the row height

   2. **Fixed Layout** - When enabled you will be able to resize your columns by dragging the headers, when not enabled the table columns will size to the data.

![Image](https://mintcdn.com/flexagon-llc-ce77a95c/NkeZh5D-Nf8j_WaD/images/fd111/12590922651.png?fit=max\&auto=format\&n=NkeZh5D-Nf8j_WaD\&q=85\&s=4ada2d1f1f7b59c35b2f47d22091b862)

## Managing Columns

To add, remove, and re-order click the **Manage Columns** button as outlined above.

![image-20240603-214317.png](https://mintcdn.com/flexagon-llc-ce77a95c/NkeZh5D-Nf8j_WaD/images/fd111/12590922654.png?fit=max\&auto=format\&n=NkeZh5D-Nf8j_WaD\&q=85\&s=07de54a7248b8aa4dafccb7767c45ec2)

1. **Adding Columns** - Simply type the column name you want to add hit enter or click the entry. You can also simply click the drop down without any text to view all available columns.

2. **Re-order Columns** - You can click and drag any column to re-order it on the table

3. **Removing Columns** - Click the trash can to remove the column from the table. 

> [!NOTE]
>
> ### Recommended Reading
>
> [Saved Queries](https://docs.flexagon.com/flexdeploy-11-1-documentation/flexdeploy-users-guide/user-profile/saved-queries.md) allow you to save all of the customizations we just went through allowing you easily access the same view every time you view the table.

***

# Exporting the Data Table

You can export the current state of the data table using the **Export** option. Clicking this option will export using your configured [User Export Settings](https://docs.flexagon.com/flexdeploy-11-1-documentation/flexdeploy-users-guide/user-profile/user-settings.md#Export-Settings) by default. Clicking the ![(blue star)](https://flexagon.atlassian.net/wiki/s/-845207469/6452/623c691c1356a9708795fbf2d3eb7953dc11488c/_/images/icons/emoticons/72/2699.png) icon will allow you to further configure the exported artifact.

![image-20250724-145833.png](https://mintcdn.com/flexagon-llc-ce77a95c/NkeZh5D-Nf8j_WaD/images/fd111/12590922657.png?fit=max\&auto=format\&n=NkeZh5D-Nf8j_WaD\&q=85\&s=c3594440511781fd42f8b3db4550570c)

When configuring the export options, the popup will initially display the values associated with your [User Export Settings](https://docs.flexagon.com/flexdeploy-11-1-documentation/flexdeploy-users-guide/user-profile/user-settings.md#Export-Settings). However you can change these values, and even set it as your default export options for the future.

![image-20250724-150152.png](https://mintcdn.com/flexagon-llc-ce77a95c/NkeZh5D-Nf8j_WaD/images/fd111/12590922660.png?fit=max\&auto=format\&n=NkeZh5D-Nf8j_WaD\&q=85\&s=4648ffdb9cf03c3783f093efe14161b6)

1. **Format**

   1. CSV - When selected, the other options below are disabled (except for numbers 6 and 7).

   2. PDF Table

   3. PDF Record

2. **PDF Page Size** - Only applies to PDF formats. For PDF Table format, this will limit how many columns you are able to export. PDF Record format has no column limitations.

   1. A0 (45 Columns)

   2. A1 (30 Columns)

   3. A2 (20 Columns)

   4. Tabloid (15 Columns)

   5. A3 (15 Columns)

   6. Legal (13 Columns)

   7. A4 (11 Columns)

   8. Letter (10 Columns)

   9. A5 (10 Columns)

   10. A6 (5 Columns)

> [!NOTE]
>
> **Note that the column number for each page size above ONLY applies for PDF Table format. PDF Record format does not have column limits.**

3. **PDF Font Size** - Can be configured between 6 and 30 (inclusive). Only applies to PDF Record format.

4. **Landscape** - Controls the page orientation. When selected, the pages will be in landscape, otherwise it will be portrait. Only applies to PDF Record format. Note that this does not affect the orientation of the content, just the page itself. Meaning each line of output will always contain only one record.

5. **Show Empty Values** - When selected, all selected columns will be present in the output even if their values are blank. Uncheck this option if you only want to see records with values present. Only applies to PDF Record format.

6. **Set as Default** - When clicked, the current state of the popup will be applied to your User Export Settings.

7. **Export** - This will submit the form and export the data table using the configured options.
