I have an Alteryx workflow that reads data from one MySQL database, processes it, and then inserts to another MySQL database using the Output Data tool. I set the Output Options to Update; Insert if New, so that it will update the record, just in case it already exists. I kept getting this Primary Key Required for Update Option, so I defined the necessary primary keys. In MySQL, EACH primary key has to be unique. My keys are a combination, so I Googled and found that, to define multiple fields as unique, you have to add indexes, so I did. I don't think Alteryx recognizes this, though, as it is still looking for the keys.
Last time I addressed this, I added an update date which had a timestamp value, so that it was sure to be unique. Any other way I can do this without adding the timestamp?
I own the database it is written to so, I can make the necessary changes, if necessary.