![]() Zoho Analytics allows you to merge datasets using a Query Table. Where can I learn more about Query Tables?ĭata merging is a method for merging similar datasets from two or more tables to create a single data set (table) for easy reporting & analysis.Can I link this query table with another table?.Can I create reports over this query table?.I got an error stating "Duplicate display columns found in your SQL Query.".I got an error stating "Kindly check the no.of columns used in select statements are equal or not".If I change the data in the parent table will it get reflected in the Query table as well?.Is there a limit for the number of tables that I can combine?.Are there any guidelines to be followed while merging two datasets?.This section will tutor you on how to use the data merging feature: Zoho Analytics uses the Query Table feature to merge datasets. You can merge the data from any number of tables and store it as a single table for reporting and analysis. What if you want to merge the "Sales 2016" data along with the "Sales 2017" data and create a consolidated table such that you can analyze the sales across all the years? This is where the data merging feature comes in handy. Let us say for instance you have a Sales database that contains yearly sales data stored as individual tables (like Sales 2016, Sales 2017 etc). But, if you wish to merge two or more datasets into a single table then you will have to use the Data Merging feature. ![]() This feature enables you to combine datasets while creating reports. Zoho Analytics allows you to link one or more tables using a feature called lookup columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |