https://community.qlik.com/t5/Data-Quality/Data-Preparation-and-Data-Integraton-Extraction-of-duplicates/m-p/2273650#M2892 Hello <BR />Take a look at tAccessInput component in Talend Open Studio for Data Integration, this component can be used to read data from Access database, and then you can ge the duplicated records with tUniqRow component, an example job looks like: <BR />tAccessInput--main--tUniqRow--duplicated--tFileOutputExcel <BR /> <BR />Hope it helps you! <BR /> <BR />Regards <BR />Shong Tue, 06 Jun 2017 06:23:24 GMT Anonymous 2017-06-06T06:23:24Z https://community.qlik.com/t5/Data-Quality/Data-Preparation-and-Data-Integraton-Extraction-of-duplicates/m-p/2273649#M2891 <P>Hello<BR />I would extract duplicates from a Microsoft ACCESS database to an excel file with Talend Data Preparation or Data Integration.<BR />Could anyone help me?<BR />Thank you.</P> Sat, 16 Nov 2024 09:46:30 GMT https://community.qlik.com/t5/Data-Quality/Data-Preparation-and-Data-Integraton-Extraction-of-duplicates/m-p/2273649#M2891 Anonymous 2024-11-16T09:46:30Z https://community.qlik.com/t5/Data-Quality/Data-Preparation-and-Data-Integraton-Extraction-of-duplicates/m-p/2273650#M2892 Hello <BR />Take a look at tAccessInput component in Talend Open Studio for Data Integration, this component can be used to read data from Access database, and then you can ge the duplicated records with tUniqRow component, an example job looks like: <BR />tAccessInput--main--tUniqRow--duplicated--tFileOutputExcel <BR /> <BR />Hope it helps you! <BR /> <BR />Regards <BR />Shong Tue, 06 Jun 2017 06:23:24 GMT https://community.qlik.com/t5/Data-Quality/Data-Preparation-and-Data-Integraton-Extraction-of-duplicates/m-p/2273650#M2892 Anonymous 2017-06-06T06:23:24Z