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!
if product is laptop then 20% discount
if product is pen then 10% discount
if product is mobile then 30% discount