For this scenario, corresponding material is retrieved and displayed for every matching entry in the field Material Code.
Level 1 Processing
Product - Material Table will be enriched as the corresponding Material will be retrieved and displayed for every matching entry in the field Material Code (MAT_CODE).
Product - Material Table (Level 1, From)
Product Code
Material Code
# Request Order
P0001
M1011
5
P0001
M1010
2
P0002
M1009
1
P0002
M1011
3
P0005
M1012
10
P0006
M1011
30
Material Table (Level 1, Lookup Auto Predicate)
Material Code
Material
Cost per Order
Unit
M1001
Paper
3
USD
M1002
Plastic
3
USD
M1003
Wax
4
USD
M1006
Botton
1
USD
M1007
Cotton
10
USD
M1009
Glass
50
USD
M1010
Lace
5
USD
M1011
Leather
10
USD
M1012
Thread
5
USD
Interim Result (Level 1)
Product Code
Materials Code
# Request Order
Material
P0001
M1011
5
Leather
P0001
M1010
2
Lace
P0002
M1009
1
Glass
P0002
M1011
3
Leather
P0005
M1012
10
Thread
P0006
M1011
30
Leather
Level 0 Processing
Level 0 Processing
The product table declared in the first rule (“From”) will now perform a Left Outer Join (for every matched product code (PROD_CODE) entry) with the Level 1 result (enhanced Product - Material Table) since result processed from a higher level will be considered as an input for the lower level.