Intended Audience for this Feature

All Users

Accessing the Spreadsheet View

Click on [Spreadsheet View] at the top right of the Asset Side Drawer screen to open a new tab in your browser, and the Spreadsheet View screen will be displayed in view mode.

Structure of the Spreadsheet View Screen

• Most of the screen is dedicated to displaying the spreadsheet. The spreadsheet shows some of the basic and detailed metadata of assets. For details on the displayed metadata, please refer to Operating the Asset Side Drawer - Viewing an Asset.
• The spreadsheet is displayed in tabs according to the asset type.
• At the bottom of the screen, there is an area that displays the asset path.
• Clicking the Copy Header to Clipboard button copies the spreadsheet header. The copied header can be pasted into spreadsheet applications (such as Microsoft Excel or Google Spreadsheets).
• The Edit button is only displayed for users with the following roles: Administrator, Data Steward, Assistant Data Steward, Developer.

Spreadsheet

Columns Displayed When Asset is DB Data

Columns Displayed When Asset is BI Data

Description of Items

Physical Name

• While holding down the Ctrl key, clicking the field link opens the clicked asset in the spreadsheet view in a new browser tab.
• Clicking the Sort icon to the right of the header sorts the rows in ascending or descending order.

Logical Name

• Clicking the Sort icon to the right of the header sorts the rows in ascending or descending order.

Rule Tag and Manual Tag

• Clicking a child tag in the field opens the Tag Glossary screen in a new browser tab, displaying the relevant tag in the Parent Tag panel and Child Tag side drawer.

Parent Owner and Owner

• Clicking the Copy icon copies the owner's email address.

Custom Property

Above the header of the custom property set, a colored indicator is displayed for each property set, allowing you to visually distinguish which columns belong to the same property set. (You cannot specify the color.)

Operations in View Mode

Icons Displayed on This Screen

The following describes operation icons on the screen that do not have text labels.

Icon	Notation in Document	Operation Available on This Screen
	Sort	Sort rows in descending order　｜　Sort rows in ascending order
	Filter	Filter the metadata to display
	Change History	Display change history of the asset
	Copy	Copy (owner's email address)
	Back	Return to the Asset Side Drawer

Operations of the Asset Path Panel

• The parent-child or ancestor relationship in the catalog leading to the asset is displayed using the physical name and an icon indicating the asset type. This is called the path.
• The asset opened in the spreadsheet view is highlighted in blue.
• If you do not have access rights to an asset displayed in the path, the asset name will be shown as unauthorized, and you cannot display the spreadsheet view by clicking it.
• Clicking an asset in the path switches the display to that asset.

Operations of the Spreadsheet Panel

Schema Tab

• When the top-level schema is highlighted in the asset path panel, its child schemas are displayed.
• When the second-level schema is highlighted in the asset path panel, its parent schema is displayed.

Table Tab

• When the top-level schema is highlighted in the asset path panel, all descendant tables of that schema are displayed.
• When the second-level schema is highlighted in the asset path panel, all tables of that schema are displayed.
• When a table is highlighted in the asset path panel, that table itself is displayed.

Column Tab

• When the top-level schema is highlighted in the asset path panel, all descendant columns of that schema are displayed.
• When the second-level schema is highlighted in the asset path panel, all descendant columns of that schema are displayed.
• When a table is highlighted in the asset path panel, all columns of that table are displayed.
• When a column is highlighted in the asset path panel, that column itself is displayed.

Column Analysis Tab

• When the top-level schema is highlighted in the asset path panel, column analysis for all descendant columns of that schema is displayed.
• When the second-level schema is highlighted in the asset path panel, column analysis for all descendant columns of that schema is displayed.
• When a table is highlighted in the asset path panel, column analysis for all columns of that table is displayed.
• When a column is highlighted in the asset path panel, column analysis for that column itself is displayed.

Search for Assets

From the search at the top right of the screen, you can perform a keyword search from the spreadsheet view. Assets whose physical or logical names match the entered keyword will be displayed.

Filtering

Clicking the Filter icon displays a side drawer for specifying filter conditions. Specify filter conditions in the side drawer to filter the assets displayed in the spreadsheet view. The following conditions can be set.

• Owner
  You can set up to 5 owners for the asset.
• Physical Name
• Logical Name
• Tag
  You can set up to 5 child tags assigned to the asset.

Unfreeze Columns or Rows

In the spreadsheet view, you can freeze columns and rows. By freezing, they will always be displayed on the screen even when you scroll.

Freeze a Column

Right-click the header of the column you want to freeze and select [Freeze Column] from the right-click menu. The column will be fixed to the left of the screen and will not move when you scroll horizontally in the spreadsheet view.

Unfreeze a Column

Right-click the header of the column you want to unfreeze and select [Unfreeze Column] from the right-click menu. The column will return to its original position.

Freeze a Row

Right-click the row you want to freeze and select [Freeze Row] from the right-click menu. The row will be fixed to the top of the screen and will not move when you scroll in the spreadsheet view.

Unfreeze a Row

Right-click the row you want to unfreeze and select [Unfreeze Row] from the right-click menu. The row will be fixed to the top of the screen and will not move when you scroll in the spreadsheet view.

Sorting

Sort Rows

Clicking the Sort icon displayed on the row number or specific column headers (Physical Name and Logical Name) sorts the row data in descending or ascending order.

Sort Columns

You can change the display order of columns. Click the header of the column you want to move, make sure the header is surrounded by a dotted line, then drag the header with your mouse and drop it at the desired position.

• The display order of columns after sorting is also applied when viewing other assets in your workspace.
• The display order of columns after sorting is retained even after logging out and logging back in.
• There is no function to reset the display order of columns to default. To restore the original order, manually sort the columns accordingly.

Check Change History

Clicking the change history icon opens a side drawer from the right of the screen displaying the change history of the asset. If there is a history, the following information is displayed.

• Edit Date
• (If edited in the spreadsheet) Edited in Spreadsheet
• Edited Asset Name
• Edited Property Set Name
• Edited Property Name
• Change Details
  • 　Added information is displayed in green.　
  • 　Deleted information is displayed in red. If text is deleted, a strikethrough will be shown.

Return to Catalog

You can close the spreadsheet view and return to the catalog screen (Asset Side Drawer) by any of the following operations.

• Close the browser tab displaying the spreadsheet view.

• Click the Back icon located to the left of the logo mark at the top of the spreadsheet view screen.