Zoho Analytics Join Tables makes it simple to combine information from two different tables into one unified view. When working with data in Zoho Analytics, you’ll often need to merge datasets, and this can be done easily using join queries or union queries. In this guide, I’ll walk you through the process step by step.
Step 1: Select the Base Table
Start by creating a Query Table.
-
Choose your first table (e.g., “Page 2021”).
-
Select the columns you want to use from this table.
-
Keep note of the order of columns — this is important when joining.
Step 2: Use a Join or Union Query
Next, you’ll join the second table (e.g., “Page 2022”).
-
If the columns are identical in both tables, use a UNION query to stack the data on top of each other.
-
If you want to connect based on matching values in different columns, use a JOIN query.
The key is to make sure column positions match when using UNION.
For example, if “Bill Amount” is in column 3 of the first table, then column 3 of the second table should also contain “Bill Amount.” Otherwise, your data will mismatch.
Step 3: Align Column Positions
When selecting columns from the second table, keep the order consistent with the first table.
-
Example: If the first table’s columns are (Invoice ID, Customer, Bill Amount), then the second table should follow the same order.
-
If column order doesn’t match, the data will be misaligned.
Step 4: Save and Check Data
Once you’ve written the query and aligned the columns, save the query table.
-
Zoho Analytics will now display a combined table containing data from both sources.
-
Review the output to confirm that the data has joined correctly.
Step 5: Extend as Needed
This method is flexible:
-
You can join two or more data tables.
-
You can also join two query tables together.
-
This allows you to build powerful consolidated datasets for reporting and dashboards.
Conclusion
Joining tables in Zoho Analytics is a powerful way to create a unified, comprehensive view of your data. Whether you’re stacking similar datasets using a UNION query or connecting related data through a JOIN, this process helps you uncover deeper insights across multiple sources. By keeping column order consistent and verifying your combined output, you ensure data accuracy and clarity. Ultimately, mastering table joins allows you to build stronger, more dynamic reports and dashboards that support smarter business decisions.
