Hi, I have a messed up text file where one of the values is in another row. I’d like to place the numeric value into the previous row under basic_pKa. There are too many rows to do my hand. If I could get that value on the same row I’m sure I could place it with a rule engine. My idea was to figure out how to pass the row with the prediction value “Yes” and the previous row and then extract and insert the value but I’m stumped on how to accomplish that and don’t have any other ideas. I’ve attached a screenshot and attached the example file.
test3.txt (1.6 KB)