Hello people of Earth
Please see below for example of data and how the updated value should look. Basically, what I want to do is if the schedule column has both "OP" and "P" for one price then the schedule should be updated to "FP". Otherwise, do not change the schedule.
Let me know if there are any questions and any help or ideas are appreciated!
Schedule | Price | Updated Schedule |
OP | 19.17 | FP |
OP | 19.17 | FP |
P | 19.17 | FP |
P | 19.17 | FP |
OP | 22.37 | OP |
OP | 22.37 | OP |
P | 47.25 | P |
P | 47.25 | P |
P | 47.25 | P |
Gelöst! Gehe zu Lösung.
Hi @Travis_Ratliff I came up with one approach using the summarise tool to concatenate the values to find the records that need changing.