In a relational database, related columns from multiple tables are joined using a foreign key. In Zoho Analytics, related columns from multiple tables are joined using a Lookup column relationship using cardinality functions. A nifty feature in Zoho Analytics is the way it supports relational data modelling. You can create or import a database consisting of multiple tables that have relationships defined between them as in a relational database.
In the relational database world, tables are related using foreign key relationships. In Zoho Analytics, this is done using the lookup column feature where a column in one table points to a column in another table. You can create or import a reporting database consisting of multiple tables that have relationships defined between them as in a relational database. To ensure that data integrity is maintained when data rows are deleted from related tables, Zoho Analytics supports the Cascade-on-Delete feature.
While creating reports, Zoho Analytics provides you with a special feature called Auto-Join that automatically joins connected tables using the lookup column. To provide a seamless import experience, Zoho Analytics provides a lightweight, standalone utility called Zoho Databridge. Once you link two tables using lookup columns, Zoho Analytics will use this information to allow you to create reports combining columns from these tables, without any additional effort. On top of the lookup table you have created by joining the necessary tables, Zoho Analytics allows you to create any type of reports for analysis and visualisation.