You can edit a data set name, rearrange the data set columns, and delete columns. You can also select the columns to use for the data set’s unique composite key. Make sure to select a combination of columns that makes the key unique.

 

To work with data sets, go to the left navigation panels, click  , then select Data Sets.   

 

  1. Select a data set in the Data Sets list.
  2. Click , then click Edit Data Set.
  3. To rename the data set, change the Name.
  4. To rearrange the columns, just drag a column to a new position in the list.

  5. To mark a column as the unique key (or multiple columns for a composite key), click the Key icons.


    Note, if the key columns data is NOT unique, the system will prevent you from saving.

  6. To mark the datatype of a column as numerical or alphabetical, toggle the A or # icons.

  7. To delete a column, hover over it and click . Click Yes to confirm.

  8. Click Save.