- OneStream Community
- Forums
- Workflow and Data Integration
- Duplicate Source Lines From Data Source
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Duplicate Source Lines From Data Source
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2023 08:09 AM
Hello there,
In an Import WF profile, I would like to duplicate all rows where the UD3 member is different than None. In the duplicated row, I need to change the UD3 POV to 'None'
I know this can be done easily through 'Derivative Rules', however I am trying to do so in the Data Source through a 'Complex Expression' or 'Business Rule'.
PS: This is bad practice since source data should NOT be altered to keep Audit trails, but in my case I am just exploring possible options
- Labels:
-
Data Sources
-
Import
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2023 09:12 AM
Hi @Keyser_Soze ,
What kind of datasource are you using? Flat file, connector, DM Sequence?
Thansk
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2023 09:39 AM
Hey man, I'm using a 'Delimited File' data source. I'm sorry I didn't think it would be relevant
- Custom table limitation in Workflow and Data Integration
- BI Blend : No valid Datakeys (Scenario/Time) found in Data Source in Workflow and Data Integration
- 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
- Range Transformation Rule not working in Workflow and Data Integration
- vStageSourceAndTargetData Converted Amount in Reporting
