Loading lastest excel file automatically into qlikview

[tripatirao]

Hi All,

Below I have attached the qlikview file which will load data from MAY JUNE JULY AUG SEPT

Now I will have excel file for OCTOBER ,

My requirement is how to load only OCTOBER month data and adding into existing qvd.

I have also attached the excel file name for reference.

Regards

Tripati

[kaushiknsolanki]

Hi,

Have a look at the post below.

Incremental Load of New Files Only

Regards,

Kaushik Solanki

[its_anandrjs]

Hi,

Why not there is separate folder for the latest excel file

Latest Excel File

E:\CCMP\Latest\

Source Excel File

E:\CCMP\Source\

Ex:-

LOAD Player,

     Run

FROM

(ooxml, embedded labels, table is Sheet1);

STORE AllData into ;

Regards

Anand

[tripatirao]

Hi Kaushik,

Thanks for your reply.

I got following sample code frOM Dyanamic load of excel files from folder

let path_Alles = 'C:\FileName*.xlsx';

Files: LOAD * FROM Files.qvd;          // to be executed only if Files.qvd exist already, i.e. after the second run

for each File in filelist (path_Alles)

     IF NOT EXISTS (FileName, $(File)) THEN

           AllData:

           LOAD * FROM $(File) (ooxml, embedded labels, table is Display);

          Files:          // Add the current file-name to the list of files

          LOAD '$(File)'     AS FileName AUTOGENERATE 1;

      END IF

next File

STORE Files INTO Files.qvd (qvd);

I am not able to implement this code in my application because how File,FileName using in the code.

Can you please help me regarding this

Regards

Tripati

[tripatirao]

Dear All,

I tried below script to load only lastest excel file in qlikview and store in existing qvd.But it is not working.

Table22:

LOAD Player,

     Run

FROM

[..\QVD\Table1.qvd]

(qvd);

for each File in filelist ('E:\CCMP\Source\*.xlsx')

IF NOT EXISTS (FileName, $(File)) THEN

Table2:

LOAD Player,

     Run

FROM

[..\Source\*.xlsx]

(ooxml, embedded labels, table is Sheet1);

END IF

next File

STORE Table22 into E:\CCMP\QVD\Table22.qvd;

Please check.

Regards

Tripati