Question

Merging manufacturers into one

  • 7 July 2020
  • 1 reply
  • 81 views

Userlevel 7
Badge +21

Master parts have manufacturers. A number of them have been combined in the real world (either consolidated or bought or whatever). What would your idea be how to generate a new manufacturer and move the ‘old’ manufacturer parts under the new one?

Steve


1 reply

Userlevel 7
Badge +21

I think I have some steps that help me.

I prepared an Excel migration job that inserts data in a new migration conversion list.

It contains the old manufacturer as the old value and, you guessed it right, the new value contains the manufacturer number that the old one has to merge to.

In an after loop on the Excel migration job, another migration job is started that takes the conversion list values as input and uses them to prepare new rows of data.

Maybe it helps you when you look for something like this.

Steve

Reply