Home
Trillion-Row Spreadsheet
The Trillion-Row Spreadsheet (TRS) allows you to visually interact with your data.
Analyze
The Analyze tab displays the object browser and the Analysis Timeline.
Object browser
The object browser provides a hierarchy of folders and objects to which you have access. Use the object browser to select the base table or query for your analysis.

Trillion-Row Spreadsheet
The Trillion-Row Spreadsheet (TRS) allows you to visually interact with your data.
- Analyze
  The Analyze tab displays the object browser and the Analysis Timeline.
  - Object browser
    The object browser provides a hierarchy of folders and objects to which you have access. Use the object browser to select the base table or query for your analysis.
    - Favorites list
      The favorites list displays of list of your favorite tables and queries.
    - <table> panel
      The <table> panel allows you to create a new temporary table on which to base your analysis.
    - Foreign database panel
      The Foreign database panel allows you to select a table from a connected database outside of the 1010data Insights Platform to use as the basis of your analysis.
    - Open an existing table or query
      Open an existing 1010data Insights Platform table or query in the Trillion-Row Spreadsheet (TRS).
    - Open a favorite table or query
      Open a favorite 1010data Insights Platform table or query in the Trillion-Row Spreadsheet (TRS).
    - Create a temporary table
      You can create a temporary table in the Trillion-Row Spreadsheet (TRS) on which to base your analysis.
    - Open a foreign table
      Open a table from a connected database outside of the 1010data Insights Platform in the Trillion-Row Spreadsheet (TRS).
  - Analysis Timeline
    The Analysis Timeline displays a visual representation of your data analysis in the Trillion-Row Spreadsheet.
  - Selecting rows
    Selecting rows is one of the most basic tasks in the 1010data Insights Platform. Use row selection to isolate data that is important to your analysis and create more efficient queries.
  - Sorting rows
    You may reorder the rows of a table such that the values in a particular column are in ascending or descending order.
  - Arranging columns
    You can display a subset of the columns in a table and specify the order in which they appear.
  - Linking tables and worksheets
    Use linking to combine tables or worksheets into a single, bigger table with columns from both.
  - Computed column
    A computed column is a column that you add to a table, whose values are typically based on one or more existing columns.
  - Summarizations and tabulations
    Some of the basic ways to analyze your data include quick summaries, tabulations, and cross tabulations.
  - Merging tables and worksheets
    You can merge two or more tables or worksheets to combine their rows together into a single, larger worksheet.
  - Amending values
    Replace the values in a table or worksheet using the amend operation.
  - Running custom code
    You can run custom SQL, Python, R, or K3 code within the TRS Analysis Timeline.
  - Miscellaneous operations
    In addition to the five basic operations, you can choose to use a miscellaneous operation in the Trillion-Row Spreadsheet.
- Query
  The Query tab displays the current timeline query as Macro Language XML code. It also provides the ability to undo and redo operations in the timeline.
- View
  Select among the ways to view and interact with the data resulting from your analysis.
- Visualize
  The 1010data Insights Platform provides a mechanism to generate high-quality charts, which in turn can support the notion of visual data discovery.
- Develop
  Use the query that represents your analysis as a base for further development.
- Export
  Export the data resulting from your analysis to various destinations.
- Results pane
  The results pane is displayed on the right side of the Trillion-Row Spreadsheet window and Macro Language Workshop.

Object browser

The object browser provides a hierarchy of folders and objects to which you have access. Use the object browser to select the base table or query for your analysis.

When a new TRS window is opened, the object browser is displayed in the Analyze tab.

The object browser is used to browse for and select the table or query on which to base your data analysis. A search feature is provided to help you locate existing folders, tables, and other objects.

Additional options allow you to choose a table or query from your list of favorites, create a new temporary table, or select a table from a foreign database.

Figure 1. Object browser

Favorites

The Favorites button displays of list of your favorite tables and queries. If you have not added any tables or queries to your favorites list, this button is not available.

New Table

The New Table button opens the <table> panel which allows you to create a new temporary table using Macro Language code.

Foreign

The Foreign button opens the Foreign database panel which allows you to select a table from a connected database outside of the 1010data Insights Platform.

Search

The search field helps you locate objects such as folders, tables, and queries. For more information, see Search.

Object browser

The object browser, located below the search field, allows you to browse for objects while maintaining a hierarchical perspective. This is the default view in a new TRS window.

To expand a folder, either click the Expand () icon or double-click the folder. To collapse a folder, either click the Collapse () icon or double-click the folder.

The object browser displays the title of the object. Place the pointer over the Information () icon to view the complete path name of the object.