add name of file as a dimension in the load script

[samuel_brierley]

HI all,

I have 20x21 spreadsheets (different names) all with the exact same dimensions the only difference between them is the names. obviously this is going to cause a slight issue, my way around this would be to add a dimension in the load script called "Source" and loading that dimension with the name of the file.

any help is greatly appreaciated

[qlikoqlik · Accepted solution]

Hi Samuel

Using the filename() function in the load script you can do this.

Load *, filename() as Source from......

Thanks and regards

PAdma