Sort columns

To sort the data by a column, select Sort Ascending or Sort Descending from the Data Prep Options dropdown menu.

To sort by several columns at the same time, select Advanced Sort for the first column. Then add additional columns in their sort order.

Sorting columns require that all data columns have the same number of rows. If the column lengths are unequal, you will be prompted to make them equal to proceed.

Change column data type

To change a single column's data type, select Change Type from the Data Prep Options dropdown menu.
  • Change a numeric column to text or date/time.
    Note

    Numeric columns can have one of the following types: Automatic (Numeric), Integer, Decimal, Currency, or Percentage.

  • Change a text column to numeric or date/time.
  • Change a date/time column to numeric or text.

Select Retain full precision to keep numeric precision. In the data grid, the numeric value displays as formatted, but the full precision value is retained to pass to other applications.

Deselect Retain full precision to round the value as formatted. Formatted, not precise values, are passed to other applications.

For more information on data types, go to Types of numeric data.

Rename column

To rename a data column, select Rename from the Data Prep Options dropdown menu.

Use the following requirements for column names.
  • Use unique names.
  • Use names between 1 and 31 characters.
  • Use names without the following characters: # '
  • Use names that do not start with the following character: *
Note

If you rename a column in the Data Center that connects to an asset in a Dashboard, the asset will not update.

Reorder columns

To change the order of the columns, drag and drop the selected columns or use the keyboard arrow keys.

Drag columns

To organize the order of one or more data columns, select Reorder Columns from the Data Prep Options dropdown menu.

Single column selection
Select the drag handle or anywhere in the row to select the column to reorder. The entire row that contains the column name can be moved.
Multiple column selection
  1. Select the first column, then press and hold the Shift key to select the last column. All columns between the first and last column are selected.
  2. Then, drag the block of selected columns to the new insertion point.
  3. Release the mouse to insert the columns.

Only adjacent columns can be selected for multiple column selection.

Use keyboard shortcuts to reorder columns

To organize the order of one or more data columns, select Reorder Columns from the Data Prep Options dropdown menu.

Single column selection
  1. Tab into column list, then use the keyboard arrow keys to select a single column.
  2. Use Enter, Return or Space to select the column.
  3. Use the keyboard arrow keys to position the column.
  4. Use Enter, Return or Space to insert the column.
Multiple column selection
Use Shift + Up/Down Arrow to select multiple columns. Use Enter, Return or Space to select and move the columns.

Only adjacent columns can be selected for multiple column selection.

Filter rows

To filter the rows of data to meet a condition, select Filter Rows from the Data Prep Options dropdown menu.

Numeric filter options
  • equals
  • does not equal
  • greater than
  • greater than or equal to
  • less than
  • less than or equal to
  • is missing
  • is not missing
Date/time filter options
  • equals
  • does not equal
  • is after
  • is after or equal to
  • is before
  • is before or equal to
  • is missing
  • is not missing
Text filter options
  • equals
  • does not equal
  • contains
  • does not contain
  • is missing
  • is not missing
  • begins with
  • does not begin with
  • ends with
  • does not end with

You can also select and right-click an individual value within a cell to exclude or show only that value. In the case of missing values, you can show missing values or show non-missing values.

Filtering rows require that all data columns have the same number of rows. If the column lengths are unequal, you will be prompted to make them equal to proceed.

Note

If you filter rows in the Data Center and sync your data, the Dashboard assets update.

Merge columns

To merge several columns into a single text column, select Merge Columns from the Data Prep Options dropdown menu.

You can merge up to six columns. The new merged text column is added to the end of the columns.

Merging columns require that all data columns have the same number of rows. If the column lengths are unequal, you will be prompted to make them equal to proceed.

Split a text column

To split an existing text column into a series of new text columns, select Split from the Data Prep Options dropdown menu.

To define a split operation, enter a delimiter value as the list separator. By default, the default delimiter value is a comma.

Note

You can create a maximum of 11 new columns from an existing column. If a column contains a list of more than 10 separated values, only the first 10 indexed values are placed into separately created columns. The remaining list items are grouped together into a separate column (the 11th column).

Extract text values from a column

To extract specific text values from an existing text column into a new text column, select Extract from the Data Prep Options dropdown menu.

Extract offers four ways to specify how to extract the information into a new column.
  • Start and end index extracts values that include the first and last index value that you specify and all values in between.

    Suppose you have a date and location code for each invoice identifier and want to extract the month, 20250415PR. In Start Index, enter 5. In End Index, enter 6 for the 2-digit month code, in this case 04.

  • First N characters extracts the first characters from the string.

    Suppose you have a date and location code for each invoice identifier and want to extract the year, 20250415PR. In Number of Characters, enter 4 for the 4-digit year code, in this case 2025.

  • Last N characters extracts the last characters from the string.

    Suppose you have a date and location code for each invoice identifier and want to extract the location code, 20250415PR. In Number of Characters, enter 2 for the 2-digit location code, in this case PR.

  • From list extracts values between the starting and ending index values.

    Suppose you have location information that includes county, city, state, and zip code, and you want to extract the city, Jefferson County, Arvada, CO, 80003. In List Delimiter, enter ,. In Extract at Index, enter 2 for the city, in this case Arvada.

Replace values in a column

To find and replace non-missing and missing text and numeric values that are contained in the specified column, select Replace Values from the Data Prep Options dropdown menu or the column context menu. The validity of the find value is determined by the column's data type and user's regional settings.

For text columns, you can also specify the following options.
  • Require letter casing to match the find value.
  • Require an exact match to the find value. This means that the whole word needs to match in order to replace the value.

Prepend or append values to data values

To add characters to the beginning or end of contents in text columns, select Prepend or Append Values from the Data Prep Options dropdown menu.

In this example, change the column to Text, then prepend the number symbol to the beginning of the claim number.
Note

Append works the same way, but places the text at the end of the data values.

Apply capitalization rules to values in a column

To specify the capitalization format for text values in a column, select Change Case from the Data Prep Options dropdown menu. Select one of the following options.
Uppercase
Capitalize all letters.

For instance, SALES ASSOCIATE.

Lowercase
Do not capitalize any words.

For instance, sales associate.

Proper case
Capitalize the first letter of each word.

For instance, Sales Associate.

Sentence case
Capitalize the first letter of the first word.

For instance, Sales associate.

Delete column

To delete a data column, select Delete Column from the Data Prep Options dropdown menu. You can also select the column and press Delete on the keyboard. To select a column, select the column title cell or the column summary cell.