I have a simple database I will use to track orders for my own purposes, this has been setup on zoho. I require a solution to this problem on zoho:
I have one CSV file like this:
SalesRecord, ProductCode, TrackingNumber
1 . A001,
2, A002
3, A002
4, A003
I have another CSV file like this:
ProductCode, TrackingNumber
A001, XX345
A002, XX346
A003, XX347
I want to import file 1 and then file 2 to have database records like this:
SalesRecord, ProductCode, TrackingNumber
1 . A001, XX345
2, A002, XX346
3, A002,
4, A003, XX347
As you can see the tracking number has been added to the records from spreadsheet 1, but in the case of A002 the tracking number has been added to the first available 'blank' record with the second A002 number being left blank.
The next day import this:
ProductCode, TrackingNumber
A002, XX348
The database then becomes:
SalesRecord, ProductCode, TrackingNumber
1 . A001, XX345
2, A002, XX346
3, A002,
XX348
4, A003, XX347
Any ideas how to do this?