Duplicate Source Lines From Data Source

New Contributor III

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



Valued Contributor

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

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

New Contributor III

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