Skip to main content
Contributor
Dec 6, 2023 1:09 PM UTC

Duplicate Source Lines From Data Source

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

 

2 replies

Veteran
Dec 6, 2023 2:12 PM UTC

Hi Keyser_Soze ,
What kind of datasource are you using? Flat file, connector, DM Sequence?
Thansk

Contributor
Dec 6, 2023 2:39 PM UTC

Hey man, I'm using a 'Delimited File' data source. I'm sorry I didn't think it would be relevant