Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello dears
i want Load All Excel File In Folder Dynamically
I wrote as follows no particular problem
-----------------------------------------------------------------------------------
Sales :
LOAD
FileName() as FileName,RowNo() as RowNumber,
OrderDate,
Region,
Rep,
Item,
Units,
[Unit Cost],
Total
FROM
Sales_*.xls
In this image, that's no problem
But if Wrote
Only a file called
What difference does the above code with the following code
Load * , FileName() as FileName,RowNo() as RowNumber;
LOAD
OrderDate,
Region,
Rep,
Item,
Units,
[Unit Cost],
Total
FROM
Sales_*.xls
-----------------------------------------------------------------------------------
The second code is using what is called a 'preceding load', maybe have a look at
http://www.quickintelligence.co.uk/preceding-load-qlikview/
to help you with understanding it
hope that helps
Joe
I think that's an issue with using the wildcard * in your filename and the preceding load.
The preceding load should work correctly when you use a For Each vFile in FileList(..) .... NEXT vFile instead of the wildcard (there is a sample in the HELP on how to use for each).