I need to get the value when they find coincidences from load editor (not as measure):
Input data:
ID Material | Value | Referencia Material | Status
1234567 | -36 | 1234567 | O 1234555 | -15 | 1234555 | O 2567190 | 40 | 1678456 | C
2463891 | 15 | 1234555 | C
2567176 | 20 | 1234568 | O
Expect data:
ID Material | Value | Reference Material | Status | Value 2
1234567 | -36 | 1234567 | O |-36 1234555 | -15 | 1234555 | O |15 2567190 | 40 | 1678456 | C |40
2463891 | 15 | 1234555 | C | 15
2567176 | 20 | 1234568 | O | 20
Basically in the input table I have the Reference Material with two repeat values (1234555) row 2 and 4, I need to get the value when the status is C from the Value column in the row when the status is O, as you can see the value in the Value 2 columns correspond to 15 in the row 2, this value correspond to the Value column in row 4.
