Create New Table | Zoho Analytics On-Premise

Creating a New Table


Zoho Analytics provides different options to create a table to store your tabular data. As already discussed, once you create a workspace you can create any number of tables within it. Please note that only Server Administrators and Managers can create new tables. To know more about the user roles in Zoho Analytics, click here.  

When you create a table in a workspace using any of the options provided, you need to provide a name which is mandatory and it should be unique in that workspace. You can optionally provide a description of the table.

Click on the +Create icon at the top left corner of the workspace or every report/table in the workspace and then choose New Table. On clicking, various options to create a table will be listed which are discussed below.

 

 Create Table by Importing data from Files & Feeds

You can create a new table by importing the data you have locally stored in tabular file formats like CSV, TSV, XLS & XLSX (Excel), XML, JSON and HTML files. The data in such formats could also be available as a URL or Web feed. You would like to import or copy and paste such data into Zoho Analytics to jumpstart your analysis and reporting over it.

You can read detailed step-by-step instructions on how to create a table by importing data from files & feeds by referring to the document Import data from Files & Feeds.

 Create Table by Importing data from Cloud Storage

You can also create a table by importing data from different Cloud Storage/Drive such as Google Drive, Dropbox, Box and OneDrive, where you have stored your data in the CSV, Excel (XLS and XLSX), JSON, HTML and ziped files.

To know how to import data from a cloud storage, refer here.

 Design a New Table from scratch

You can create a new table from scratch, by defining the columns to be present along with its properties (like type, default value etc.,). You might add data subsequently into this table or import data from an external file into this table. To create a table from scratch using the Using Design View option.

The following list explains the fields to be filled while designing a table.

  • Column Name: Provide the name of the column. Name should be unique in a table.
  • Data Type (Column Type): Choose the data type/column type of the column.
  • Mandatory: If the column should have a mandatory value and cannot be empty, set this value as Yes. If not, set this to No.
  • Default: Provide any default value that has to be present in the column, in case no data is entered. Refer to the specific data type document to know about the possible default values that could be provided for each column type.
  • Lookup column: In case this column is of type Looked Up column, where it refers (or lookup) to a column in another table, then you need to choose the column to be looked up from the corresponding table as value to this column. Lookup columns are useful to relate two tables in a workspace and thus enabling you to create reports combining data from column across the related tables (Refer Auto Joining Tables for Reporting). The Lookup column option is also the way for creating a workspace which is relational. Read more about Lookup Column.
  • Formula: You can add a formula only after saving the table once. After saving the table once you will see a Add Formula link in this column to add a formula column. Refer to Creating Formula Columns document.
  • Description: Provide a description to explain the purpose of the corresponding column.

Once you have added the necessary columns in the table, click Save in the toolbar. The Save dialog will pop up. Provide the name and description of the table. Click OK to save the table.

You can edit or delete a column by clicking the settings icon (which appears on mouseover) and then select the corresponding option.

 

 Enter Data Right Away

If you are a Microsoft Excel or Spreadsheet user who would like to first enter the data into the tables and then worry about naming the columns or formatting them, then choose the Enter data Right Away.

In the sheet, you can start entering the data that you wish to add under the respective columns named Column1, Column2 etc., You can also rename the column headers by double-clicking on them and providing a name. As mentioned already, do ensure that column names are unique in a table.

Once you are done with your data entry, click the Save button in the toolbar. This will prompt the Save dialog where you need to provide the name of the table (mandatory) and description (optional). The new table will be created with the given name, including the newly added data and columns.

Note:

  • Anytime you can rename a table by clicking on the Edit icon   seen on the top-left corner of the tab in which the table is displayed. The edit icon will be visible only when you mouse over the tab. Clicking on the icon, the table name will become editable. You can modify the name and press the Enter key to save the table with the new name.

You can also rename a table from the Navigation Tree on the left, which lists all the view in the workspace or from the Reports Explorer.


    Access your files securely from anywhere

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION









                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • Creating a new pivot table

                                                                                                                A Pivot Table allows you to dynamically summarize large amounts of data for easy analysis and visualization. You can transform data in a table(s) into meaningful summaries easily by using the intuitive drag and drop interface provided by Zoho ...
                                                                                                              • Creating a new tabular view

                                                                                                                With Zoho Analytics' intuitive drag-and-drop report builder, you can easily create a tabular view within minutes. This document explains the various steps involved in creating the required tabular view. Creating a tabular view Follow the steps below ...
                                                                                                              • Pivot Table

                                                                                                                Pivot Table allows you to dynamically rearrange, group and summarize data for easy analysis of large sets of data. You can transform data in a table(s) into interactive and meaningful summaries easily by using intuitive drag and drop interface ...
                                                                                                              • Creating Reports

                                                                                                                Zoho Analytics offers a wide variety of reporting options such as Charts, Pivot tables, Summary views and Tabular views. This enables you to easily analyze your data and derive great insights. The intuitive drag and drop based designer of Zoho ...
                                                                                                              • Customizing a pivot table

                                                                                                                When designing a pivot table, Zoho Analytics offers a wide range of options to customize it and improve the overall appearance in different ways. In this section we will discuss about various options provided by Zoho Analytics to customize a pivot ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources