Mload: Update duplicate rows

Tools
Enthusiast

Mload: Update duplicate rows

Hi,

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.
1 REPLY
Enthusiast

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.