Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_brierley
Creator
Creator

add name of file as a dimension in the load script

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

1 Solution

Accepted Solutions
qlikoqlik
Creator
Creator

Hi Samuel

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

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

Thanks and regards

PAdma

View solution in original post

1 Reply
qlikoqlik
Creator
Creator

Hi Samuel

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

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

Thanks and regards

PAdma