topic Re: Load excel files where the name start with s in Management & Governance https://community.qlik.com/t5/Management-Governance/Load-excel-files-where-the-name-start-with-s/m-p/63472#M1118 <HTML><HEAD></HEAD><BODY><P>You can use wildcard in the script</P><P>s*.xls </P></BODY></HTML> Mon, 21 May 2018 09:10:29 GMT tomasz_tru 2018-05-21T09:10:29Z Load excel files where the name start with s https://community.qlik.com/t5/Management-Governance/Load-excel-files-where-the-name-start-with-s/m-p/63471#M1117 <HTML><HEAD></HEAD><BODY><P>Hello everybody,</P><P></P><P>I would like to load some excel files from a LIB and the condition that i load all fields of an excel file where the name start with *s*</P><P></P><P>Thanks for help </P></BODY></HTML> Mon, 21 May 2018 08:57:46 GMT https://community.qlik.com/t5/Management-Governance/Load-excel-files-where-the-name-start-with-s/m-p/63471#M1117 zied_ahmed1 2018-05-21T08:57:46Z Re: Load excel files where the name start with s https://community.qlik.com/t5/Management-Governance/Load-excel-files-where-the-name-start-with-s/m-p/63472#M1118 <HTML><HEAD></HEAD><BODY><P>You can use wildcard in the script</P><P>s*.xls </P></BODY></HTML> Mon, 21 May 2018 09:10:29 GMT https://community.qlik.com/t5/Management-Governance/Load-excel-files-where-the-name-start-with-s/m-p/63472#M1118 tomasz_tru 2018-05-21T09:10:29Z Re: Load excel files where the name start with s https://community.qlik.com/t5/Management-Governance/Load-excel-files-where-the-name-start-with-s/m-p/63473#M1119 <HTML><HEAD></HEAD><BODY><P>can you please give me an example ? </P><P></P><P>Thank you</P></BODY></HTML> Mon, 21 May 2018 09:12:03 GMT https://community.qlik.com/t5/Management-Governance/Load-excel-files-where-the-name-start-with-s/m-p/63473#M1119 zied_ahmed1 2018-05-21T09:12:03Z Re: Load excel files where the name start with s https://community.qlik.com/t5/Management-Governance/Load-excel-files-where-the-name-start-with-s/m-p/63474#M1120 <HTML><HEAD></HEAD><BODY><P>Hi Zied </P><P></P><P>Try this -</P><P></P><P>LOAD *</P><P>FROM</P><P><C></C></P><P>(biff, embedded labels, table is Sheet1);</P><P></P><P>Where&nbsp; '*' is a wild character</P></BODY></HTML> Mon, 21 May 2018 09:21:48 GMT https://community.qlik.com/t5/Management-Governance/Load-excel-files-where-the-name-start-with-s/m-p/63474#M1120 dwarikapanigrah 2018-05-21T09:21:48Z Re: Load excel files where the name start with s https://community.qlik.com/t5/Management-Governance/Load-excel-files-where-the-name-start-with-s/m-p/63475#M1121 <HTML><HEAD></HEAD><BODY><P>Yes it works..just we need to change path to LIB Thank you</P></BODY></HTML> Mon, 21 May 2018 09:28:39 GMT https://community.qlik.com/t5/Management-Governance/Load-excel-files-where-the-name-start-with-s/m-p/63475#M1121 zied_ahmed1 2018-05-21T09:28:39Z