Manipulating a Column

TIBCO Clarity provides you a set of operations that you can use to manipulate a specific column in a project.

When uploading raw data to TIBCO Clarity, TIBCO Clarity automatically assigns a data type for each column. If you want to change the data type, click the data type icon, and then select a data type. You can define your own data types for use, see Adding New Custom Data Types.

• Faceting Column Data
  Faceting regroups your data according to your configurations. When working on a column, you can apply various faceting methods.
• Searching Column Data
  You can make a search on a specific column to find your data.
• 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.
• Editing Columns
  Various ways are available to edit columns. You can split one column into several columns, add a new column based on an existing column, change the column order, and rename and remove a column.
• Transposing Data
  Use the data transposing function to transpose cells across columns into rows and vice versa.
• Sorting Data
  Use the data sorting function to sort data by data types.