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: 
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

New column that states from which excel file the information was loaded

Hello,

What is the best practice for getting the new column that includes excel file name from which the data was loaded?

Now my script looks like this:

LOAD %Point

  ,ID

FROM

(ooxml, embedded labels, table is Sheet1);

Lets say I have 2 files: A.xlsx and B.xlsx

Thank you!

1 Solution

Accepted Solutions
marcus_sommer

You could simply add filename() as Source or filebasename() as Filename within your load-statement.

- Marcus

View solution in original post

2 Replies
marcus_sommer

You could simply add filename() as Source or filebasename() as Filename within your load-statement.

- Marcus

MindaugasBacius
Partner - Specialist III
Partner - Specialist III
Author

That's what I needed!