i need to design a dataport. which updates the data in two tables.
Here the issue is i have two tables 1. Item ( Primary key : Item No)
- Barcodes. ( Primary Key : Barcode)
Common fields of the two tables is "Item No. “, " Unit Price”. So now i will import data with fields ( Barcode, Unit Price) in Barcode table. When i importing the data into barcodes table the unit price need to update in Item table based on Item No.
I am creating the dataport based on Barcodes table.
Can any one please help me in coding part…