Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get reload file name

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?

Labels (1)
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can use the filename function:

Load *, filename() as sourcefile

from c:\data\*.xls ...etc


talk is cheap, supply exceeds demand