It is possible to read data from database tables or Excel files (.xls, .xlsx) with Expressor.
To retrieve the name of the file being processed you would need to supply the file name to the input operator through a configuration/parameter setting. If you are satisfied processing files one at a time, then your requirements can be met using Expressor Desktop. If you require that a collection of files be processed automatically, you will need to use the Expressor Standard or Expressor Enterprise products.
The best place to read about using configurations is in the product documentation.
Go to the documentation page in the Expressor community site knowledge base (http://www.qlikcommunity.com/docs/DOC-3325) and read the topic Building QlikView Expressor Applications > Configurations > What Are Configurations.
The approach that uses Expressor Standard or Enterprise requires you to understand how to use the etask command line utility to run Expressor dataflows in a command window. This is described in the product documentation in the topic Command Line Utilities > etask.
Download the free Expressor Desktop edition and try using the configuration approach.
Hello Dear Follow the instructions.
let vCount = -1;
For Each vSheet in 'Sheet1','Sheet2','Sheet3','Sheet4','Sheet5';
let vCount = $(vCount)+1;
FileBaseName()&'$(vSheet)'&F1 as KEY,
'1 Litter' as Packaging,
F2 as Date,
(biff, embedded labels, header is 2 lines, table is $(vSheet)$)
where IsNum (F2);
Hope answer the question.