Skip to content

Multi-Table Rules Overview

The multi-table rules allow to extract values from entities in 0-1 relationship (Entity) or 0-n relationship (Table) with their owner.

Example

In this exemple, variables are added in the root dictionary to extract information from the other dictionaries. The main object is a Customer which can have at most one Address and several Sales entries.

Root Dictionary Customer (customer_id)
{
Categorical customer_id;
Numerical age;
Categorical sex;
Entity(Address) customerAddress; // 0-1 relationship
Table(Sale) sales;               // 0-n relationship
};

Dictionary Address (customer_id)
{
    Categorical customer_id;
    Categorical street;
    Categorical city;
    Categorical zipcode;
    Categorical State;
};

Dictionary Sale (customer_id)
{
Categorical customer_id;
Categorical product;
Numerical cost;
Date purchaseDate;
};