Outer join - how to

Question

Hi,

please how can we define an outer join (i.e. LEFT join) when design a BM?

tks

regard

Answer 1

Hi carmy63,

During the creation of the BM it is necessary to set the cardinality to 0 to N in the relationships between the fields of the tables https://knowage-suite.readthedocs.io/en/7.4/functionalities-guide/meta-web/index.html?highlight%20=affari#crea-una-nuova-relazione

After generating the model, go to MyWorkspace, select the model you created and add the fields involved in the relationship. Using the three-dot menu at the top right of the page, you can access the "join definitions" dialog where you can select the type by choosing between INSIDE, LEFT or RIGHT.

Greetings
Alberto