Miscellaneous operations
In addition to the five basic operations, you can choose to use a miscellaneous operation in the Trillion-Row Spreadsheet.
Miscellaneous operations provide additional functionality to help simplify common analytical tasks.
The following miscellaneous operations are available:
- Expand rows
- Choose the number of times that each row appears in the table.
- Split
- Split and expand a string column on a given separator.
- Replace
- Find and replace one or more patterns within a string column.
- Date/Time
- Convert strings into dates, times, or intervals and format times and dates into strings.
- Group Metric
- Compute an aggregation, grouping by rows by one or more columns.