Draw data from multiple text files

[#1]

Hi There,

I am drawing data from multiple text files from a specific folder.
Is there a way of drawing the actual file name in as one of the columns? The idea what I have is as follows, but I do not know how to write it in QV language;

Load
Column1,
Column2,
Column3,
-File Name- AS Column4

from Folder\*.xls (biff, embedded labels, table is Sheet1$);

[#2 · Accepted solution]

there is a function called filename() in qlikview.

Load * filename( ) as X from

C:\UserFiles\abc.txt