I am trying to write a derivative rule with some logic in a complex expression.

you can't use DelimitedParsedValues in a Transformation Rule. You might have to stuff column 2 in an attribute field and use that in your rule expression. Also, you might run into issues with that setstringvalue function if you have more than 1 row with the same flight value.