LOOP CONTROL

Hello group,

I need your help!

I have a table1 with 2 columns, 1st is a reference and 2nd is a parts position that configure of reference.

I have a table2, where I have a dictionary with the position of the pieces that combines with the reference AREA.

I want to get whether the reference is FRONT, RIGHT, LEFT or REAR according to table 1, but you can see that there are multiple combinations.

For example, if I look at table one and get the reference 51123 it should classify me as FRONT.

If I have a 63333 it would be classified as RIGHT, because 2222 is shared with FRONT and RIGHT, but it depends on another position that is associated to the reference in concrete …

and if for example, there are some positions in different areas, the result should be FULL EQUIPMENT.

I want to make a workflow where I can sort each reference by FRONT, RIGHT, LEFT, REAR or FULL.

*Another question, how can I automatically run all the references in the workflow?

THANKS ALWAYS