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.
Amending values
Replace the values in a table or worksheet using the amend operation.
Amend a single value within the grid
Change the value of a cell directly from within the grid.
Amend values panel
The Amend values panel appears in the Analysis Timeline after a single value is amended within the Grid view of the Trillion-Row Spreadsheet.

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.
  - 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.
    - Amend column panel
      The Amend column panel allows you to choose a column and enter a value expression to replace values in a table or worksheet.
    - Amend values in a column using an expression
      Recompute the value of a column or specific rows of a column by using a value expression.
    - Amend a single value within the grid
      Change the value of a cell directly from within the grid.
      - Amend values panel
        The Amend values panel appears in the Analysis Timeline after a single value is amended within the Grid view of the Trillion-Row Spreadsheet.
  - 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.

Amend values panel

The Amend values panel appears in the Analysis Timeline after a single value is amended within the Grid view of the Trillion-Row Spreadsheet.

The Amend values panel displays information about a cell amended within the grid. Specifically, the panel identifies the location of the amended cell, indicated by row number and column name, and lists the cell's new value. A new line of information is created for each cell amendment performed in the grid.

The Amend values panel also allows you to edit an existing single value amendment. For example, if you accidentally made an amendment to the wrong cell in the grid, you can make the correction by changing the appropriate information in the panel.

Figure 1. Amend values panel

Row

Displays the row number in which the amended cell is located.

To change the row number of the amended value, double-click the cell, edit the number, and then submit the operation.

To restore a single amended value to its original state, right-click the appropriate row in the Amend values panel and then click Remove row from the menu.

Column

Displays the name of the column in which the amended cell is located.

To change the column location of the amended value, click the drop-down arrow in the cell, select the column, and then submit the operation.

Value

Displays the new value of the amended cell.

To change the value of the cell, double-click the cell, edit the value, and then submit the operation.

Note: If you attempt to enter a value that does not match the data type of the column (e.g., entering text in an integer column), the cell containing the invalid value is highlighted and the panel prevents you from submitting the value change.