Error in Appending Data (Pls check Error Screen)

Tue, 27 Mar 2012 14:08:32 GMT

Hello Friends,

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;

DROP table ResourceFile;

can any one help me ?????????

Regards

Ravi Gupta

topic Error in Appending Data (Pls check Error Screen) in QlikView