Loaded Files

[#1]

Hello,

I want to make an overview of the files that I've loaded into my qvw.

When I use the Filename() expression, none of the filenames show up.

Im using multiple .txt files for data.

Is there a solution on how to show these filenames? And also create an overview of the loaded files?

Thanks in advance!

[#2]

I have multiple tables, but thats done by sub directories.

All data comes from files in one load statement

[ramasaisaksoft]

if possible can u share your code so that our folks will also help to you easily.

[#4]

I wrote my script a few posts above this one and due to security reasons, I cant write down the full code.

But I think I got a lead because of preceding load issues with the filename()

[#5 · Accepted solution]

Okay guys,

Turns out that I used the filename() before a preceding load and not within the load statement itself.

So for those who are dealing with the same problem:

Define the Filename() in the load statement and if you are using preceding loads, then Load it in the Load statement and make sure you define it in the preceding load as well!

[rahulpawarb]

Hello Ivo,

You can make use of below script to the distinct list of file names loaded into datamodel:

FileList:
Load DISTINCT
      FileName() as FileName
Resident EventFact_Temp;

Hope this will be helpful.

Regards!

Rahul