Mload: Update duplicate rows

Tools & Utilities

Mload: Update duplicate rows


I want to update a table with person info.
The current table has wrong person associated to the product.
When I update, I get "Target row updated by multiple source rows"
That is because in some cases same product is assciated with more than one person.

In such a case I want to update the record already there in table and insert for the extra updates.

Is there any way of doing it using the options of Mload. Please suggest. Thank you.

Re: Mload: Update duplicate rows

I beleive Multiload supports Upsert operations.Upsert essentially updates a row id it already exists otherwise inserts it into the table.

refer manuals to know how upsert works.