topic After Concatenate Data get wrong Data in QlikView

After Concatenate Data get wrong Data

Tue, 27 Mar 2012 12:29:17 GMT

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 — Tue, 27 Mar 2012 12:32:18 GMT

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 — Tue, 27 Mar 2012 12:40:49 GMT

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

Tue, 27 Mar 2012 12:43:58 GMT

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 — Tue, 27 Mar 2012 12:47:02 GMT

can you attach sample..

sivarajs — Tue, 27 Mar 2012 12:49:55 GMT

while loading excel second time put the condition like

load *

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

Tue, 27 Mar 2012 12:52:10 GMT

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 — Tue, 27 Mar 2012 13:09:58 GMT

can you check the attached file