Forum Discussion

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago

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

Originally posted by Jon Golembiewski

11/14/2019

I am trying to write a derivative rule with some logic in a complex expression. It seems the api.parser.DelimitedParsedValues function does not work within Derivative rules? I always get back 'Index Out of Range' error. Any idea how to get it working or what function I might be able to use to replace it? I am ultimately trying to pull in the amount for a particular column in my file.

Data Sources

1 Reply

  • OSAdmin's avatar
    OSAdmin
    Icon for OneStream Employee rankOneStream Employee
    6 years ago
    Originally posted by Martin Toma

    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.