Data Sets

This section contains the information of the following actions:

Add New Column in Existing Data Set

The following are the steps to add a new column in a data set:

1. Click on the data set in which you need to add a column and edit using icons below Diagram tab.
2. Let us edit data set G_Assess. Click on G_Assess and edit the Data Set as shown below:
   

3. In the SQL Query, add any column from the available tables and click Query Builder. For example, re.onset_ve EA_onset. Once query is built successfully, the column is added to the data set G_Assess.

   

Add New Data Set

The following are the steps to add a new data set:

1. Click on New Data Set icon and select SQL Query as shown below:
   
2. Write a valid SQL statement to fetch values from the report GTTs. Enter a data set name, such as G_NewDS and select proper Data Source from the list box. Click OK.
   
3. You can see that new data set G_NewDS is created.
   
4. Save the new Data Model and verify that new data set and columns are available in the data model. Click Structure tab to give proper business names for the newly added columns. You can see new data set G_NEWDS is available. Modify the business name to G_MyDS.