When I try to append data in same qvd file then I found some error can you provide me solution & I follow some step Pls check if you hv any concern pls let me know:
I followed following steps, Please check this reply:
Step1: create qvd file from Excel sheet then store qvd file.
Step2: concanete qvd file with same excel sheet( one column status change in sheet)
Step3: After concating I check qvd file then i found no data only found xml represation data but data is not shoing.
these are step are we follow Please find out Code for your refrence:
let vDateStamp = date(today(), 'DDMMYYYY');
IF filetime('E:\Path MIS\New_Data_MIS\ResourceFile_Temp.qvd')>0 THEN
ResourceFile: LOAD RES_ID, RES_NAME, STATUS FROM (biff, embedded labels, table is Sheet1$);
Concatenate
LOAD * FROM E:\Path MIS\New_Data_MIS\ResourceFile.qvd;
STORE ResourceFile INTO E:\Path MIS\New_Data_MIS\ResourceFile.qvd;
ELSE
ResourceFile: LOAD RES_ID, RES_NAME, STATUS FROM (biff, embedded labels, table is Sheet1$);
END IF
STORE ResourceFile INTO E:\Path MIS\New_Data_MIS\ResourceFile.qvd;
it would be best if you could attach a sample qvw file with your input excel file (doesn't need to contain your real data, but should demonstrate your issue).
Then
a) What is the need for vDateStamp? You don't use it anywhere else after defining.
b) What do you mean with "( one column status change in sheet)"?
c) What do you mean with "After concating I check qvd file then i found no data only found xml represation data but data is not shoing." Are you looking at the qvd directly e.g. by using an editor or are you loading the qvd from QV?
Do you want to implement an incremental load? If so, I would recommend that you start with some of the examples here in the forum or with the one from Rob's QV cookbook available here:
