After Concatenate Data get wrong Data

[#1]

Hello friends,

I craeted one qvd file from excel data then Strore.

After that I Concatenating  qvd file and excel file then I found  no data only get xml data.

Can Anyone please help.

PLEASE FIND OUT SNAP SHOT OF ERROR SCREEN.

Regards

Ravi Gupta

[swuehl]

Ravi Gupta,

I am not sure if I understand what you are doing, could you upload your qvw file with the excel or post your script here?

[sivarajs]

Obviously it will be the same data right??

you are Loading from excel and then storing into qvd and then you are doing conatenate the xml again

I will give you the same

Sivaraj S

[#4]

Hi,

Normally, I created one qvd file through excel data again I reload same data with status change then after I get wrong data.

If you have any concern Pls help me.

Regards

Ravi Gupta

[sivarajs]

can you attach sample..

[sivarajs]

while loading excel second time put the condition like

load *

from test.xls where not exists(Status(qvd field),Status(xl field))

[#7 · Accepted solution]

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.

thease are step are we follow.

can any one help me.

Regards

Ravi Gupta

[sivarajs]

can you check the attached file