Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

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

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

MVP
MVP

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

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

Community Browser