https://community.qlik.com/t5/Talend-Studio/File-Processing-using-tFileList/m-p/2374895#M137417 <P>Hello,</P><P>If we understand your requirement very well, you could make use of the setting "Action on data" to "Insert or update on duplicate key or unique index" in your tMysqlOutput</P><P>Let us know if it is what you are looking for.</P><P>Best regards</P><P>Sabrina</P> Tue, 16 Nov 2021 03:35:24 GMT Anonymous 2021-11-16T03:35:24Z https://community.qlik.com/t5/Talend-Studio/File-Processing-using-tFileList/m-p/2374894#M137416 <P>Im using tFileList to load all the files in the directory using a wildcard i.e</P><P></P><P></P><P>tFileList----&gt;iterate---&gt; tFileInputDelimited-----&gt;Main---&gt;tMap-----&gt;Main---&gt;tMSSqlOutput</P><P></P><P></P><P>wildcard on the tFileList is filemask "cusageFin*.csv"</P><P></P><P></P><P>I have MSSQL table that has filename field to store the file name of that is loaded, however i want to be able ensure that i do not load the same file twice as i run my job. How do i make sure that i will not load the same file loaded each time i execute my job</P> Mon, 15 Nov 2021 06:55:01 GMT https://community.qlik.com/t5/Talend-Studio/File-Processing-using-tFileList/m-p/2374894#M137416 GivenM 2021-11-15T06:55:01Z https://community.qlik.com/t5/Talend-Studio/File-Processing-using-tFileList/m-p/2374895#M137417 <P>Hello,</P><P>If we understand your requirement very well, you could make use of the setting "Action on data" to "Insert or update on duplicate key or unique index" in your tMysqlOutput</P><P>Let us know if it is what you are looking for.</P><P>Best regards</P><P>Sabrina</P> Tue, 16 Nov 2021 03:35:24 GMT https://community.qlik.com/t5/Talend-Studio/File-Processing-using-tFileList/m-p/2374895#M137417 Anonymous 2021-11-16T03:35:24Z