topic Re: What difference does the above code with the following code? in QlikView

What difference does the above code with the following code?

Fri, 24 Jul 2015 10:19:34 GMT

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

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

Re: What difference does the above code with the following code?

Fri, 24 Jul 2015 10:24:41 GMT

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

Re: What difference does the above code with the following code?

swuehl — Fri, 24 Jul 2015 10:27:25 GMT

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