Skip to main content
December 6, 2023

Duplicate Source Lines From Data Source

  • December 6, 2023
  • 2 replies
  • 0 views

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

December 6, 2023

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

December 6, 2023

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