topic Extracting the source data file name in QlikView https://community.qlik.com/t5/QlikView/Extracting-the-source-data-file-name/m-p/211502#M712523 <HTML><HEAD></HEAD><BODY><P>See the use of filename() and filebasename() in the script.</P><P>Regards,</P><P>Gordon</P></BODY></HTML> Thu, 02 Dec 2010 18:26:05 GMT 2010-12-02T18:26:05Z Extracting the source data file name https://community.qlik.com/t5/QlikView/Extracting-the-source-data-file-name/m-p/211501#M712522 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I am loading some data from multiple Excel files using the following code:</P><P><STRONG>for i = 0 to 20</STRONG></P><P><STRONG>CONCATENATE LOAD<BR /> [Type],<BR /> [Date],<BR /> [Country],</STRONG></P><P><STRONG>// XXXXXXX as [Source File Name]</STRONG></P><P><STRONG>FROM<BR />[Data*.xls] (biff, embedded labels, table is data$);</STRONG></P><P><STRONG>next</STRONG></P><P>I would need to set up the field (<STRONG>[Source File Name]</STRONG>) where I would be storing the name of the each source file for each record I am loading.</P><P>Any suggestions will be greatly appreciated.</P><P></P><P>Best regards,</P><P>Vladimir</P></BODY></HTML> Thu, 02 Dec 2010 18:16:51 GMT https://community.qlik.com/t5/QlikView/Extracting-the-source-data-file-name/m-p/211501#M712522 2010-12-02T18:16:51Z Extracting the source data file name https://community.qlik.com/t5/QlikView/Extracting-the-source-data-file-name/m-p/211502#M712523 <HTML><HEAD></HEAD><BODY><P>See the use of filename() and filebasename() in the script.</P><P>Regards,</P><P>Gordon</P></BODY></HTML> Thu, 02 Dec 2010 18:26:05 GMT https://community.qlik.com/t5/QlikView/Extracting-the-source-data-file-name/m-p/211502#M712523 2010-12-02T18:26:05Z Extracting the source data file name https://community.qlik.com/t5/QlikView/Extracting-the-source-data-file-name/m-p/211503#M712524 <HTML><HEAD></HEAD><BODY><P>It works perfectly. Thank you!</P><P>Regards,</P><P>Vladimir</P><P></P></BODY></HTML> Thu, 02 Dec 2010 18:55:59 GMT https://community.qlik.com/t5/QlikView/Extracting-the-source-data-file-name/m-p/211503#M712524 2010-12-02T18:55:59Z