Problem regarding creating QVD..

[nikhilgarg]

Hey,

I am having a problem in creating qvd.

I initially created qvd and opened it with notepad.

Now whatever qvd i am creating it is by default in notepad form. So , Kindly help me What to do because may be qlikview not able to read qvd in notepad form.

Please help.

THanx

[nikhilgarg]

HEy Nitin,

I have resolved the issue.

I have used the Tablefiles option to load the excel files.

NOw the code is like :

Directory;

LOAD Id,

     StartDate,

     EndDate,

     Country,

     Type,

     Sub_Type,

     Name,

     Killed,

     Injured,

     Year

FROM

[Disaster_Data\Copy of Disaster.xlsx]

(ooxml, embedded labels, table is Disaster);

Concatenate

LOAD Id,

     StartDate,

     EndDate,

     Country,

     Type,

     Sub_Type,

     Name,

     Killed,

     Injured,

     Year

FROM

disaster1.qvd (qvd) WHERE NOT Exists(Id);

STORE Disaster INTO C:\Users\nikhil.garg\Desktop\disaster1.qvd;

But i want to ask if i have to use incremental load for insert based on LAst execution time. How can i do it ??

I mean "last execution time" of table should compare with "Modification time of table" and give the updated rows only not the whole data of table. How can i do it ??

[#3]

i hope you got my point now.

if you are loading data from desktop , load statement dnt have SQL keyword as prefix.

please close this with making mark 🙂

-Thanks.

[nikhilgarg]

HEy,

Ohk , btw you on linkeidn ??