https://community.qlik.com/t5/Talend-Studio/Getting-2-recent-files-from-FTP-difference-on-output/m-p/2327264#M96657 <P>Hello everyone,</P> <P>&nbsp;</P> <P>I'm having some troubles finding a solution to my problem. Here it is :&nbsp;</P> <P>&nbsp;</P> <P>I have access to an FTP server where i want to get the 2 newer files (XML), compares them &amp; only get the difference as an CSV output.<BR />Some more details :</P> <P>My files on my FTP always looks: TEXT_yyyyMMdd_hhmm&nbsp; &nbsp;, like that :<BR /><BR /></P> <P>TEXT_20180408_0950.xml<BR />TEXT_20180409_0950.xml<BR /><SPAN>T</SPAN><SPAN>EXT</SPAN><SPAN>_20180410_0950.xml<BR /><BR /></SPAN>So here i would like to only extract the&nbsp; &nbsp;<SPAN>T</SPAN><SPAN>EXT_</SPAN><SPAN>20180408_0950.xml&nbsp; &nbsp;&amp;&nbsp; &nbsp;&nbsp;</SPAN><SPAN>T</SPAN><SPAN>EXT</SPAN><SPAN>_20180409_0950.xml. If the files looks like that :<BR /></SPAN></P> <P>&nbsp;</P> <P><SPAN>TEXT_20180408_0950.xml&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEXT_20180409_0950.xml</SPAN></P> <P>&nbsp;</P> <P><SPAN>&lt;store&gt;001&lt;/store&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;store&gt;001&lt;/store&gt;<BR />&lt;ID&gt;1&lt;/ID&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;ID&gt;1&lt;/ID&gt;<BR />&lt;qty&gt;20&lt;qty&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;qty&gt;18&lt;qty&gt;<BR />&lt;price&gt;3&lt;/price&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;price&gt;3&lt;/price&gt;<BR />&lt;country&gt;1&lt;/country&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;country&gt;1&lt;/country&gt;<BR />&nbsp;</SPAN></P> <P><SPAN>I want my output to be just :&nbsp;</SPAN></P> <P><SPAN>&lt;store&gt;001&lt;/store&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<BR />&lt;ID&gt;1&lt;/ID&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<BR />&lt;qty&gt;18&lt;qty&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<BR />&lt;price&gt;3&lt;/price&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<BR />&lt;country&gt;1&lt;/country&gt;<BR /><BR />But if the lines are exactly the same, I want nothing in my output, and if in the 08/04 files there is a line which is not anymore in the 09/04 files,I want the line with 0 as quantity.<BR /><BR />I'm currently blocked at only get the 2 newer files, i used a tFileList with a tFileInputXML with : "&nbsp;(String)globalMap.get("tFileList_1_CURRENT_FILEPATH") " as FILENAME but I dont see how get the second one. If someone have some idea how I could do all this stuff.<BR /><BR />Sorry for the long post, I tried to be as much specific as I can.<BR /><BR />Really appreciate your time &amp; help,&nbsp;</SPAN></P> Tue, 15 May 2018 10:25:40 GMT daez 2018-05-15T10:25:40Z https://community.qlik.com/t5/Talend-Studio/Getting-2-recent-files-from-FTP-difference-on-output/m-p/2327264#M96657 <P>Hello everyone,</P> <P>&nbsp;</P> <P>I'm having some troubles finding a solution to my problem. Here it is :&nbsp;</P> <P>&nbsp;</P> <P>I have access to an FTP server where i want to get the 2 newer files (XML), compares them &amp; only get the difference as an CSV output.<BR />Some more details :</P> <P>My files on my FTP always looks: TEXT_yyyyMMdd_hhmm&nbsp; &nbsp;, like that :<BR /><BR /></P> <P>TEXT_20180408_0950.xml<BR />TEXT_20180409_0950.xml<BR /><SPAN>T</SPAN><SPAN>EXT</SPAN><SPAN>_20180410_0950.xml<BR /><BR /></SPAN>So here i would like to only extract the&nbsp; &nbsp;<SPAN>T</SPAN><SPAN>EXT_</SPAN><SPAN>20180408_0950.xml&nbsp; &nbsp;&amp;&nbsp; &nbsp;&nbsp;</SPAN><SPAN>T</SPAN><SPAN>EXT</SPAN><SPAN>_20180409_0950.xml. If the files looks like that :<BR /></SPAN></P> <P>&nbsp;</P> <P><SPAN>TEXT_20180408_0950.xml&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEXT_20180409_0950.xml</SPAN></P> <P>&nbsp;</P> <P><SPAN>&lt;store&gt;001&lt;/store&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;store&gt;001&lt;/store&gt;<BR />&lt;ID&gt;1&lt;/ID&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;ID&gt;1&lt;/ID&gt;<BR />&lt;qty&gt;20&lt;qty&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;qty&gt;18&lt;qty&gt;<BR />&lt;price&gt;3&lt;/price&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;price&gt;3&lt;/price&gt;<BR />&lt;country&gt;1&lt;/country&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;country&gt;1&lt;/country&gt;<BR />&nbsp;</SPAN></P> <P><SPAN>I want my output to be just :&nbsp;</SPAN></P> <P><SPAN>&lt;store&gt;001&lt;/store&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<BR />&lt;ID&gt;1&lt;/ID&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<BR />&lt;qty&gt;18&lt;qty&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<BR />&lt;price&gt;3&lt;/price&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<BR />&lt;country&gt;1&lt;/country&gt;<BR /><BR />But if the lines are exactly the same, I want nothing in my output, and if in the 08/04 files there is a line which is not anymore in the 09/04 files,I want the line with 0 as quantity.<BR /><BR />I'm currently blocked at only get the 2 newer files, i used a tFileList with a tFileInputXML with : "&nbsp;(String)globalMap.get("tFileList_1_CURRENT_FILEPATH") " as FILENAME but I dont see how get the second one. If someone have some idea how I could do all this stuff.<BR /><BR />Sorry for the long post, I tried to be as much specific as I can.<BR /><BR />Really appreciate your time &amp; help,&nbsp;</SPAN></P> Tue, 15 May 2018 10:25:40 GMT https://community.qlik.com/t5/Talend-Studio/Getting-2-recent-files-from-FTP-difference-on-output/m-p/2327264#M96657 daez 2018-05-15T10:25:40Z