![]() While creating reports, Zoho Analytics will list all the tables that have a lookup relationship in the Column list panel of the Report designer. Zoho Analytics allows you to define a lookup relationship from the import wizard, the table or from the report editor. In Zoho Analytics, tables with lookup relationships can be joined in the following two ways: Lookup columns can be used to join tables where you need to retrieve data from two or more tables in a Workspace. Note: When you manually create a lookup relationship, Zoho Analytics does not check the data columns if the data values adhere to the mentioned cardinality type. In a Many-to-One relationship, the parent table will have unique values and the child table will contain duplicate values. Each element in the "1" attribute corresponds to one or more elements in the "N" attribute, and each "N" attribute corresponds to one and only one element in the "1" attribute. In a One-to-Many relationship, the parent table will have unique values and the child table will have duplicate values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |