Data Uploads Overview

1. Navigate to DATA on the SDA menu bar, then select TABLES.
   
   
   
   
2. Navigate to the ACTIONS drop-down menu and select UPLOAD DATA.
   
   
   
3. Click BROWSE YOUR FILES and choose the appropriate data file from your file browser.
   
   
   

   After you have selected the data file, the data upload dialog box will display the name of data file you will upload.

4. Answer the structure-related questions about the data file at the bottom of the screen, then click NEXT.
   
   
   
5. Review the data file's column names. Edit the names, if necessary. Click NEXT.
   
   
   
6. From the SET COLUMN TYPES dialog box, review the values in each column. Use the drop-down menu above each column to edit the column types, if necessary.
   

   When you join an uploaded data file to a worksheet, the data types (also called column types) must be the same for the join to be successful.   Click the drop-down arrow above each column to display the available data types. The drop-down menu on the far right has been expanded to display the available data types.




The values in the column must be the same data type as the data type that you define in the drop-down menu for that column. For example, if the values in your data file column are text fields, the data type that you select in the drop-down menu for that column must also be "text."     Do not upload metrics or values in a data file that you intend to aggregate. Search-driven Analytics will aggregate your data, but the results will be incorrect.



7. Click UPLOAD. A confirmation dialog box will display indicating that the values in the data file were successfully imported.
   
   
   
   
   
   
8. To view the newly-uploaded values, select DATA from the SDA menu, then select TABLES.
   
   
   
   
9. Select the name of the data file you uploaded.
   
   
   
10. View the results in the pane on the right.
    
    
    
    
    After a spreadsheet has been imported, you will need to join the data file to a worksheet.