Hide and show columns
Hide or unhide columns in your data table to display just the data that you need to work with.
Individual columns can be hidden clicking the arrow icon that appears when hovering over a column header and selecting Hide.
To hide several columns:
- Select the columns you want to hide clicking their headers.
- Select Column operations → Hide selected columns. You can also hide the columns you didn't select clicking Hide unselected columns.
In case of data tables with a large amount of columns, you can select the Search column layout icon on the toolbar. Using this option, you can easily look for columns using the search box in the window and hide the ones you don't need by deselecting them. This comes in handy when you are querying a data table that contains a great amount of information.
When you access a data table using a finder, you can hide columns before opening the data table. The Search column layout icon turns green when you pick specific columns when running a search or when you hide columns in the query window.
To show all the hidden columns, click Column operations → Show hidden columns.
Individual columns can be unhiding by selecting the Search column layout icon on the toolbar and checking the columns you want to show.