Need File Auto Load Help in Qlikview

[#1]

Dear All,

I want to help in qlikview.

I have a Folder Name AAL every day the save some excel. and load then edit script some code then view.

Note: How auto load qlikview next new excel then auto script.

Note: Please see the print Screen attachment file (Auto Update).

Example:

LOAD [Sl. No.],

     [Type of Expense],

     [Purpose in Details],

     [Name of Employee],

     Designation,

     [Department/ Section],

     [No of Day/s],

     Particulars,

     F9,

     F10,

     Amount,

     Remarks,

     Left(Filebasename(),4) as Year,

Mid(Filebasename(),5,2) as Month,

Mid(Filebasename(),7,2) as Day,

Right(Filebasename(),3) as Factoryname,

FileBaseName() as Name

FROM

(ooxml, embedded labels, header is 2 lines, table is FactoryExpenses);

[ashfaq_haseeb · Accepted solution]

Hi,

Check this Solution attached.

LOAD [Sl. No.],
     [Type of Expense],
     [Purpose in Details],
     [Name of Employee],
     Designation,
     [Department/ Section],
     [No of Day/s],
     Particulars,
     F9,
     F10,
     Amount,
     Remarks,
     Left(Filebasename(),4) as Year,

Mid(Filebasename(),5,2) as Month,

Mid(Filebasename(),7,2) as Day,

Right(Filebasename(),3) as Factoryname,

FileBaseName() as Name
FROM

(ooxml, embedded labels, header is 2 lines, table is FactoryExpenses);

Regards

ASHFAQ

[maxgro]

You can load many excel files with standard DOS wildcard characters ( * and ? ).

This will cause all the matching files in the specified directory to be loaded.

LOAD

    ............

FROM

(ooxml, embedded labels, header is 2 lines, table is FactoryExpenses);

or

LOAD

    ............

FROM

(ooxml, embedded labels, header is 2 lines, table is FactoryExpenses);

[its_anandrjs]

Hi,

If you want to load many excel files which is in the raw source folder then use ( * ) symbol for this and if you know the file name start with any string then use  2015*.xlsx other wise you can use *.xlsx only

LOAD [Sl. No.],

     [Type of Expense],

     [Purpose in Details],

     [Name of Employee],

     Designation,

     [Department/ Section],

     [No of Day/s],

     Particulars,

     F9,

     F10,

     Amount,

     Remarks,

     Left(Filebasename(),4) as Year,

     Mid(Filebasename(),5,2) as Month,

     Mid(Filebasename(),7,2) as Day,

     Right(Filebasename(),3) as Factoryname,

     FileBaseName() as Name

FROM

(ooxml, embedded labels, header is 2 lines, table is FactoryExpenses);

Regards

Anand

[#5]

Thank's

[#6]

Thank's