OWB - Joiner operator

About

The Joiner operator joins multiple row sets from different sources with different cardinalities, and produces a single output row set. The Joiner operator results in a WHERE clause in the generated SQL query. A Joiner can have unlimited number of input groups but only one output group.

You can use the Joiner operator to define a join condition :

You can also create self joins by using a filter operator.

You use the Joiner operator to join multiple row sets from different sources and produce a single output row set.

It's the equivalent in Sql to this statement :

select * from
   TableA,
   TableB
where
   TableA.id = TableB.id

where

TableA.id = TableB.id

is the join condition that you define in the join operator.

Join condition

You can change the join condition (TableA.id = TableB.id) in the operator properties. Click in the operator bar on the Joiner text, in the left side, you can then change this value.

_

You can add comments in condition than you don't use SQL statement such as AND … in it.

INOUTGRP1.ATTR_GROUP_ID = 169 
/* the same filter than
ego_attr_groups_v.attr_group_type = CS_SR_CONTEXT en 
ego_attr_groups_v.attr_group_name = XXGBR_KS_VORDERINGEN */

Do not use the join condition to:

  • include aggregation functions
  • add a filter

use instead respectively a aggregate operator and a filter operator

Reference


Powered by ComboStrap