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.
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.
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.
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.
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.
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:
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.
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
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.
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.