Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Have a look at the post below.
Incremental Load of New Files Only
Regards,
Kaushik Solanki
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
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
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