Hi @ppr : As you suggested, I took different approach this time.
I have used inner join activity (1 to n mapping) and create one table which contains multiple records of unique id.
Now i have to create multiple rows of unique id to single row in different table after applying business rules during processing.
Apply add data rows is not solving this problem statement.
Id Price Discount Allowance1 Allowance2 Status
1 12 5 0 1.1 successful
1 12 5 1.3 0 successful
Expected Output
Id Price Discount Allowance1 Allowance2 Status
1 12 5 1.3 1.1 successful
Note : There are around 50 columns in PROD data table