https://community.qlik.com/t5/Talend-Studio/Duplicate-entry-XXXXXX-for-key-PRIMARY/m-p/2271179#M48859 Hi<BR />The column is a primary key, the value "MD1209573642" already exists in table. How to solve the problem? It depends on your request, you have two choice:<BR />1. Check the option 'die on error' on the output DB component, the job throw the exception and dies.<BR />2. Uncheck the option 'die on error', the problematic rows are rejected into the reject flow and the job continue to process next row. Link a reject data flow after the output DB component, you will get all the problematic rows. For example:<BR />tFileIputDelimited--main--tMysqlOutput--reject--tLogRow Sat, 25 Aug 2012 13:44:50 GMT Anonymous 2012-08-25T13:44:50Z https://community.qlik.com/t5/Talend-Studio/Duplicate-entry-XXXXXX-for-key-PRIMARY/m-p/2271178#M48858 Hi, <BR />When I need to combine/append 2 tables together, i encounter below error: <BR />Duplicate entry 'MD1209573642' for key 'PRIMARY'. <BR />How to solve this problem? Any one know? <BR />Regards <BR />Benjamin Marcus Sat, 25 Aug 2012 06:04:58 GMT https://community.qlik.com/t5/Talend-Studio/Duplicate-entry-XXXXXX-for-key-PRIMARY/m-p/2271178#M48858 Anonymous 2012-08-25T06:04:58Z https://community.qlik.com/t5/Talend-Studio/Duplicate-entry-XXXXXX-for-key-PRIMARY/m-p/2271179#M48859 Hi<BR />The column is a primary key, the value "MD1209573642" already exists in table. How to solve the problem? It depends on your request, you have two choice:<BR />1. Check the option 'die on error' on the output DB component, the job throw the exception and dies.<BR />2. Uncheck the option 'die on error', the problematic rows are rejected into the reject flow and the job continue to process next row. Link a reject data flow after the output DB component, you will get all the problematic rows. For example:<BR />tFileIputDelimited--main--tMysqlOutput--reject--tLogRow Sat, 25 Aug 2012 13:44:50 GMT https://community.qlik.com/t5/Talend-Studio/Duplicate-entry-XXXXXX-for-key-PRIMARY/m-p/2271179#M48859 Anonymous 2012-08-25T13:44:50Z