PowerTable provides several options to help you search, organize, and analyze data in a table. You can search for records, sort and reorder columns, show or hide columns, pin columns for easier navigation, and view column insights to better understand your data.
In this article, you learn how to:
Use the Search box to quickly locate records by entering text, numbers, or phrases.
To search for records:
Select the Search box on the toolbar.
PowerTable sheet filters the table and displays matching records as you type. Search results are returned across all pages of the table.
PowerTable provides standard sorting options to organize records in ascending or descending order based on the values in a selected column. You can sort numeric and non-numeric columns, including numbers, text, dates, and single-select fields.
To sort records:
Hover over the required column header and select the three-dot menu.
Select Sort Ascending or Sort Descending.
The following example shows the ProductSKU column sorted in ascending order.
To remove sorting, select Remove Sort from the same menu.
You can reorder columns to customize the table layout.
To change the position of a column, drag the column header and drop it in the required location.
The following example shows the ProductSKU column reordered next to the ProductName column.
You can hide columns that are not required for your view and display them again when needed.
To hide a column:
Select the three-dot menu and then select Hide.
The ProductDescription column is hidden from the table view.
To display all hidden columns, select Show All Columns from the menu on any column header.
Pinning keeps important columns visible on the left while you scroll horizontally through the table.
To pin a column:
Select the three-dot menu, and then select Pin.
The pinned ProductName column moves to the left side of the table and remains visible during horizontal scrolling.
You can pin multiple columns if required.
To remove a pinned column, select Unpin from the same menu. To remove all pinned columns, select Unpin All.
Use Insights to view summary statistics and key information about a column. Column insights help you quickly understand data distribution, completeness, and trends without creating additional calculations.
To view column insights:
Select the three-dot menu, and then select Insights.
Depending on the column data type, the following insights are available:
Use these insights to identify patterns, validate data quality, and make informed decisions. The following example shows column insights for a few columns.
To view all available insights for the selected column, select Show All in the Insights dropdown.
You can also access the Sort, Hide, Pin, and Insights options from the toolbar after selecting a column.
The Column Profile option provides a quick summary of the data in each column. It displays the number of Filled, Empty, Unique, and Distinct values, so you can assess data completeness and identify potential data quality issues.
To view the column profile:
Select Format > Column Profile on the toolbar.
PowerTable displays a profile row below the column headers. The profile includes:
The Data Cleanup option improves data quality by removing duplicate and empty values from a selected column.
To clean up data:
Select one of the following options:
