topic Re: Need File Auto Load Help in Qlikview in QlikView

Need File Auto Load Help in Qlikview

Sun, 02 Nov 2014 05:03:05 GMT

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

Re: Need File Auto Load Help in Qlikview

ashfaq_haseeb — Sun, 02 Nov 2014 06:00:43 GMT

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

Re: Need File Auto Load Help in Qlikview

maxgro — Sun, 02 Nov 2014 06:23:49 GMT

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

LOAD

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

FROM

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

Re: Need File Auto Load Help in Qlikview

its_anandrjs — Sun, 02 Nov 2014 06:33:51 GMT

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

Re: Need File Auto Load Help in Qlikview

Sun, 02 Nov 2014 07:21:11 GMT

Thank's

Re: Need File Auto Load Help in Qlikview

Sun, 02 Nov 2014 07:22:02 GMT

Thank's