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: 
Not applicable

What difference does the above code with the following code?

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

01.png

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

02.png

-----------------------------------------------------------------------------------

2 Replies
Not applicable
Author

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

swuehl
MVP
MVP

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).