https://community.qlik.com/t5/App-Development/Max-FileName-and-Data-Load/m-p/2012884#M83718 <P>G'day,</P> <P>This requires a few steps. I'll briefly outline them and hopefully that will get you going.</P> <P>1. load a list of file names in a folder. See <A href="https://community.qlik.com/t5/QlikView-App-Dev/List-of-files-in-a-folder/td-p/648029" target="_self">this old article</A> (it should still work).</P> <P>2. parse the names of the files to get the dates by using something like this:</P> <P> date( right( BaseFileName(), 10 ), 'DD.MM.YYYY' )</P> <P>3. filter out the undesired dates</P> <P>4. loop through the remaining rows in the table to load up each of those files</P> <P>Cheers, Barnaby.</P> Mon, 05 Dec 2022 21:31:15 GMT barnabyd 2022-12-05T21:31:15Z https://community.qlik.com/t5/App-Development/Max-FileName-and-Data-Load/m-p/2012629#M83705 <P>Hi,</P> <P>I want to load max file data from the folder.</P> <P>How to identify the max file from folder?</P> <P><STRONG>Example: input</STRONG></P> <P>File01.01.2022 to 02.02.2022</P> <P>File01.01.2022 to 03.02.2022</P> <P><STRONG>File01.01.2022 to 04.02.2022 -&gt; only this file data need to be upload.</STRONG></P> <P> </P> <P>File02.01.2022 to 02.02.2022</P> <P>File02.01.2022 to 03.02.2022 <STRONG>-&gt; only this file data need to be upload.</STRONG></P> <P><STRONG>Example: output</STRONG></P> <P>File01.01.2022 to 04.02.2022</P> <P>File02.01.2022 to 03.02.2022</P> Mon, 05 Dec 2022 10:51:39 GMT https://community.qlik.com/t5/App-Development/Max-FileName-and-Data-Load/m-p/2012629#M83705 profilejamesbond 2022-12-05T10:51:39Z https://community.qlik.com/t5/App-Development/Max-FileName-and-Data-Load/m-p/2012884#M83718 <P>G'day,</P> <P>This requires a few steps. I'll briefly outline them and hopefully that will get you going.</P> <P>1. load a list of file names in a folder. See <A href="https://community.qlik.com/t5/QlikView-App-Dev/List-of-files-in-a-folder/td-p/648029" target="_self">this old article</A> (it should still work).</P> <P>2. parse the names of the files to get the dates by using something like this:</P> <P> date( right( BaseFileName(), 10 ), 'DD.MM.YYYY' )</P> <P>3. filter out the undesired dates</P> <P>4. loop through the remaining rows in the table to load up each of those files</P> <P>Cheers, Barnaby.</P> Mon, 05 Dec 2022 21:31:15 GMT https://community.qlik.com/t5/App-Development/Max-FileName-and-Data-Load/m-p/2012884#M83718 barnabyd 2022-12-05T21:31:15Z