Editing Cells

TIBCO Clarity provides you a set of operations to edit cell values. You can update a specific cell or update a batch of cells at a time.

To edit one cell value, move your mouse pointer over the cell value, and then click Edit to enter a new value.

On the project data page, click the header of the column containing the values that you want to edit, and then click Edit cells, the following cell editing options are available:

  • Transforming Cells
    You can apply text transforming, numeric transforming, and other common transforming to the cells in a column.
  • Blanking and Filling Cells
    In a column, you can use the blanking down function to clear the cells that contain the same value as a preceding cell, and use the filling down function to fill empty cells with the value contained in a preceding column.
  • Splitting and Merging Cells
    You can split the cells in a column into rows if the cells contain multiple values delimited by a separator. Similarly, you can merge multiple cells into a row.
  • Clustering Cells
    Use this function to find a group of different cell values that might be alternative representations of a same thing.