Expand rows

Choose the number of times that each row appears in the table.

The expand rows operation allows you to duplicate rows in your table. You can choose the number of times that each row should appear in the table. You can also create a computed column to index expanded rows, which can make it easier when querying the subsequent data.

To expand rows:

  1. In the New operation panel, click Expand Rows.
    The Trillion-Row Spreadsheet displays the Expand panel.

  2. In the Expression Editor field, enter a value expression.

    For more information, see Writing Expressions in the 1010data Reference Manual. For more information about the Expression Editor, see Expression Editor.

  3. Optionally, to create a computed column to index expanded rows, complete the following:
    1. Select the Create column to index expanded rows option.
      The Trillion-Row Spreadsheet displays indexing fields and options.

    2. In the Index column name field, enter a name for the new column.
    3. In the Starting index field, enter or select the number at which to start indexing the expanded rows.
  4. Click the Submit operation () icon.
    The Trillion-Row Spreadsheet displays the results of the expand operation.