storing excel file name as a variable

[dreweezy]

How do I go about storing my excel file name into a variable in qlik sense?

I am going through a bunch of excel files that need conversion into qvd. Lets say my excel file name is "2019 File 1..", "2019 File 2..", etc.

I am trying to use this script below:

FOR vCount = 0 to NoOfTables()-1

LET vTableName = TableName($(vCount));

STORE $(vTableName) INTO 'lib://personalpath/$(vTableName).qvd' (qvd);

NEXT vCount

The variable vTableName wouldn't work since all of these workbooks have the same name - "Sheet1"

[DavidM]

If all of the workbooks have same name, they are probably all concatenated to one table when loading. You need to add NoConcatenate after your load statement

Your storing script is fine

[wcilliers]

You should be able to use filename()

LET vFilename = FileName();