Greetings,
I have a situation where I am sent a database dump from another company. I'll simplify the structure:
item, desc, qty, cost, mfg_item1, mfg_item2,mfg_item3
The problem is, I need to cross reference this data against our own database, which uses the mfg_item as the primary key so ideally I need a way to transform the table they send me into a strucutre like this:
mfg_item, item, qty, cost
so that a new row is created for each instance of mfg_item from the old table and the item, desc, qty, cost and filled in for each new row that is added.
Any suggestions on how I can pull this off?
Regards.
Start Free Trial
