Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem in Appending Data

Hi ,

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;

DROP table ResourceFile;

can any one help me.

Regards

Ravi Gupta

6 Replies
Not applicable
Author

Hello friends,

Can Anyone Please reply?

Regards

Ravi Gupta

sivarajs
Specialist II
Specialist II

Hi,

can u check this condition is working

IF  filetime('E:\Path MIS\New_Data_MIS\ResourceFile_Temp.qvd')>0 THEN

Sivaraj S

Not applicable
Author

Hi Sivaraj,

Thanks for reply!

Metioned codition is running.

First try to understand my problem. While appending the data in qvd file second time i am facing the problem.

Pls check all code already given.

Kindly help me.

Regards

Ravi Gupta

sivarajs
Specialist II
Specialist II

your attachment is not opening can u check that

swuehl
MVP
MVP

Ravi Gupta,

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:

http://robwunderlich.com/downloads/

Regards,

Stefan

Not applicable
Author

Hi Stefen,

  Thanks for reply.

I will provide you qvw file tomorrow.

Thanks & Regards

Ravi Gupta