Loading files from folder using LOAD DISTINCT Filename

[#1]

I currently have an excel document in a folder with 3 tabs containing data. Using the Load distinct function, Qlikview returns the filename.

However, as soon as I add another tab to the excel document, Qlikview returns a null value for the filename. Any idea what I am doing wrong?

[Anonymous]

Post sample data so that it is easy to understand..

[rwunderlich]

Please post your script.

-Rob