Multiple file data validation with Transformation rules

Help
1

Hi All,

i have source (Product_sheet) and target (output_sheet) files data as below. i need to validate data as per Transformation rules.

Does anybody know how to do it? Thanks a lot!

Rules:
Product_id,discount
if product is laptop then 20% discount
if product is pen then 10% discount
if product is mobile then 30% discount

Product_sheet

product_id,Product_name,qty,Rate
1,Laptop,20,25000
2,Pen,30,350
3,Mobile,20,35000
4,Fridge,10,16000

output_sheet
Product_id,Product_name,QTY,Rate,TotalAmount,finalAmount(afterdiscount)
1,Laptop,20,25000,500000,400000
2,Pen,30,350,10500,9450
3,Mobile,20,700000,560000
4,Fridge,10,16000,160000

Thanks
Sreenu

2

I have attached an work flow please go through it Main.xaml (34.3 KB)