Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in Appending Data (Pls check Error Screen)

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

0 Replies