I have a export job which export data to mysql server over SSL. It works fine. But I have situation where I might get duplicate data in datameer and need to ignore the duplicate record and insert the non-duplicated data. I have set primary keys on mysql server table.
Exported okay into mysql server.
In a later run I have below data in my workbook
But I want to insert 333 and 177 recrods into datameer. And ignore 111 record which is already there in mysql server.
I tried skip error and drop record options in export job. But in both the cases the export job fails it doesn't export the non-duplicated data into mysql server.
Please suggest if there is way to work around it.
Please sign in to leave a comment.