- OneStream Community
- Forums
- Workflow and Data Integration
- I am trying to write a derivative rule with some logic in a complex expression.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
I am trying to write a derivative rule with some logic in a complex expression.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-16-2020 07:27 AM
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.
- Labels:
-
Data Sources
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2020 09:37 AM
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.
- How can I ( if possible ) set a UD static value from a data source based on contents of a column in Workflow and Data Integration
- Data source Complex Expression in Logical Operator in Workflow and Data Integration
- How to Get Prior Workflow Period Amount in Complex Expression in Application Build
- Duplicate Source Lines From Data Source in Workflow and Data Integration
- Loading Amount and Annotations together in Workflow and Data Integration
