Add a Table in Sheets enabled DW

Overview

You can easily add a table in Discovery Wizard by importing Google Sheets.

Step-by-Step Guide

1. Follow the steps to Integrate with Google Sheets.

2. Click Discovery Wizard on the Visualizer Type page.

   
   
3. Follow the steps to Add Sections and Categories in Discovery Wizard.

4. Click to select the section or category where you want to add a table.

   
   
5. Click Add Table.

6. Enter a name in the Table Name field.

   
   

7. Enter the number of rows and columns directly in the spin box or click the up-down control to select the numeric value.

   
   

8. Select the position of the table by clicking the appropriate tab.

   
   
9. Enable the Notes toggle button to add a section for notes. For a step-by-step guide, follow the steps to Add Notes to a Table in Sheets enabled DW.

10. Click Select Data Range.

11. The imported Google spreadsheet appears.

    
    

12. Hover the mouse over a cell. You can see a finger icon. Ensure to select both variables as well as values.

    
    

13. Click on the mouse's left button and drag it to where you want the data to be copied. You can see the entire data range getting selected. (You can also press Downward +Shift key on the keyboard to make the selection.)

    
    
14. Click Create.

15. If you want to retain the table that you created, click the Save button on the top navigation.

16. You can see the entire table on the Prototype page.

16. Enable Google Sheets Mapping to know the cell reference. For a step-by-step guide, follow the steps to Enable Google Sheets Mapping.

Editing the General Settings

1. Click the pencil icon to edit the general settings.

2. The Table General Settings pop-up box appears.

   
   

3. You can change the Name of the Table as well as Position of the table.

   
   

4. You can also enable or disable the Notes toggle button.

   
   

5. Enabling the Hide Header toggle button would remove the table titles.

   
   
6. Click Save. The table modifies as per the changes made.

Deleting the Table

1. Click the trash icon to delete the table.

Copying the Table

1. Click the copy icon

2. To move the table to another section, select from the Section drop-down list and then click Move.

   
   
3. To copy the table in another section, select from the Section drop-down list and then click Copy.

Copying the Table with Tags

1. Follow the steps to Copy the Code Reference of an Entire Table in Sheets enabled DW.