topic Loading lastest excel file automatically into qlikview in QlikView

Loading lastest excel file automatically into qlikview

tripatirao — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Loading lastest excel file automatically into qlikview

kaushiknsolanki — Wed, 02 Nov 2016 07:12:29 GMT

Hi,

Have a look at the post below.

Incremental Load of New Files Only

Regards,

Kaushik Solanki

Re: Loading lastest excel file automatically into qlikview

its_anandrjs — Wed, 02 Nov 2016 07:16:08 GMT

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

Re: Loading lastest excel file automatically into qlikview

tripatirao — Wed, 02 Nov 2016 09:15:14 GMT

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

Re: Loading lastest excel file automatically into qlikview

tripatirao — Wed, 02 Nov 2016 13:07:09 GMT

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