Hello Guys
Is there a way that we can execute a recursion logic in board for example, for the productnumber ADVE0001, we are looking for conversion from ctn to kg, so we need to
look for the fromunitsymbol where it is ea and tounitssymbol = kg, this is the simplest scenario
from CTN to ea and
ea to kg
It could have been from a to b
b to d
d to e
e to kg
PRODUCTNUMBER | FROMUNITSYMBOL | TOUNITSYMBOL | DENOMINATOR | FACTOR |
---|
ADVE0001 | ctn | ea | 1 | 6.0000000000000000 |
ADVE0001 | ea | kg | 1 | .4720000000000000 |
ADVE0001 | layer | ctn | 1 | 12.0000000000000000 |
ADVE0001 | layer | ea | 1 | 72.0000000000000000 |
ADVE0001 | pl | ctn | 1 | 156.0000000000000000 |
ADVE0001 | pl | ea | 1 | 936.0000000000000000 |
ADVE0001 | pl | layer | 1 | 13.0000000000000000 |
Any idea please, should it be done through loop ?
Thanks