Discussion Board for collaboration on QlikView Scripting.
I am loading some data from multiple Excel files using the following code:
for i = 0 to 20
CONCATENATE LOAD [Type], [Date], [Country],
// XXXXXXX as [Source File Name]
FROM[Data*.xls] (biff, embedded labels, table is data$);
I would need to set up the field ([Source File Name]) where I would be storing the name of the each source file for each record I am loading.
Any suggestions will be greatly appreciated.
Go to Solution.
See the use of filename() and filebasename() in the script.
It works perfectly. Thank you!