topic Re: Get reload file name in QlikView https://community.qlik.com/t5/QlikView/Get-reload-file-name/m-p/563261#M210191 <HTML><HEAD></HEAD><BODY><P>You can use the filename function:</P><P></P><P>Load *, filename() as sourcefile</P><P>from c:\data\*.xls ...etc</P></BODY></HTML> Thu, 11 Jul 2013 13:00:01 GMT Gysbert_Wassenaar 2013-07-11T13:00:01Z Get reload file name https://community.qlik.com/t5/QlikView/Get-reload-file-name/m-p/563260#M210190 <HTML><HEAD></HEAD><BODY><P>Hi, I have a file that the data comes from several Excel files. The thing is that somewhere something is wrong, when I plot charts I have a field " - ", that is representing around 3% of the total now. I need to track down those wrong names, and change it manually in my Excel files. As I have like 200 files, I was wondering if I could get the excel file name in the qlikview, which would be much easier to track them down. How do I do that?</P></BODY></HTML> Thu, 11 Jul 2013 12:54:47 GMT https://community.qlik.com/t5/QlikView/Get-reload-file-name/m-p/563260#M210190 2013-07-11T12:54:47Z Re: Get reload file name https://community.qlik.com/t5/QlikView/Get-reload-file-name/m-p/563261#M210191 <HTML><HEAD></HEAD><BODY><P>You can use the filename function:</P><P></P><P>Load *, filename() as sourcefile</P><P>from c:\data\*.xls ...etc</P></BODY></HTML> Thu, 11 Jul 2013 13:00:01 GMT https://community.qlik.com/t5/QlikView/Get-reload-file-name/m-p/563261#M210191 Gysbert_Wassenaar 2013-07-11T13:00:01Z