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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

Problem regarding creating QVD..

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

32 Replies
nikhilgarg
Specialist II
Specialist II
Author

Hey,

I am not putting any dsn name. Niether using ODBC connection. Please help.

Anonymous
Not applicable

Please give me exact Error message

Moreover without ODBC connection how this error is coming???????

Please check you are retrieving data via SQL statement. So you have to connect to a data base via connection string then only a SQL statement can execute..

nikhilgarg
Specialist II
Specialist II
Author

Hey,

Following 3 errors are coming :

1:  ODBC connection failed

SQL ODBC CONNECT32 TO [Excel Files;DBQ=C:\USERS\NIKHIL.GARG\DESKTOP\DISASTER_DATA\Copy of Disaster.xlsx]

2 : ODBC connection failed

Sql SELECT Id, StartDate, EndDate, Country, Type, Sub_Type, Name, Killed, Injured, Year FROM 'C:\Users\nikhil.garg\Desktop\DISASTER_DATA\[Copy of Disaster.xlsx]' WHERE ModificationTime >= #2014-09-05 14:12:58#

3: Cannot open file 'C:\Users\nikhil.garg\Desktop\disaster1.qvd WHERE NOT Exists[Id]' The system cannot find the file specified.

Concatenate

LOAD Id, StartDate, EndDate, Country, Type, Sub_Type, Name, Killed, Injured, Year FROM C:\Users\nikhil.garg\Desktop\disaster1.qvd WHERE NOT Exists[Id]

Not applicable

Hi,

make sure SQL select statement should have object( table ,from which you wish to extract data) at the end of the load statement in the script.

where you are extracting new data ?  from SQL or local desktop ?

because your SQL Script is not having correct end tags.please check once.

"SQL SELECT Id,  StartDate, EndDate, Country, Type, Sub_Type, Name, Killed, Injured, Year FROM 'C:\Users\nikhil.garg\Desktop\Disaster_Data\[Copy of Disaster.xlsx]'

after FROM keyword script is not having correct destination path.so that you are getting Connection error.

- Charitha.

nikhilgarg
Specialist II
Specialist II
Author

Hey,

My data (excel sheet) is on local desktop.

Now i have used following by hit and trial now it is giving only 1 error.

Please help me .

Directory;

LOAD Id,

     StartDate,

     EndDate,

     Country,

     Type,

     Sub_Type,

     Name,

     Killed,

     Injured,

     Year

FROM

[Copy of Disaster.xlsx]

(ooxml, embedded labels, table is Disaster);

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

ODBC CONNECT32 TO [Excel Files;DBQ=C:\Users\nikhil.garg\Desktop\Disaster_Data\Copy of Disaster.xlsx] (XUserId is dAHCfQRMNLacWZA, XPassword is QDdXaQRMNLacGMA);

SQL SELECT * FROM `C:\Users\nikhil.garg\Desktop\Disaster_Data\Copy of Disaster.xlsx`.`Disaster$`

WHERE ModificationTime >= #$(LastExecTime)#;

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;

----------------------------------------------------------------------------------------------------

Now it is giving me following error :

SQL##f - SqlState: 07001, ErrorCode: 4294964286, ErrorMsg: [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1.

SQL SELECT * FROM `C:\Users\nikhil.garg\Desktop\Disaster_Data\Copy of Disaster.xlsx`.`Disaster$`

WHERE ModificationTime >= #2014-09-05 14:12:58#

Please help

Thanx.

Not applicable

if you are loading from desktop, it should't have SQL keyword.

please ensure that is it correctly done or not

Not applicable

i can show the difference

from SQL:

LOAD EmployeeCode,

    Password,

    FirstName,

    LastName,

    PhoneNumberCode,

    EmailAddress,

    ManagerId,

    ResetPassword,

    "RoleIdentifier_ID",

    ActiveFlag,

    ModifiedDate,

    CreateDatetime,

    Location;

SQL SELECT *

FROM RM.dbo.Employee;

from Desktop:

LOAD

EmployeeCode,

    Password,

    FirstName,

    LastName,

    PhoneNumberCode,

    EmailAddress,

    ManagerId,

    ResetPassword,

    "RoleIdentifier_ID",

    ActiveFlag,

    ModifiedDate,

    CreateDatetime,

    Location

FROM

INPUT.txt

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

your script is mixed up both.so please correct that.then you wont get connection pblm.

-Charitha

nikhilgarg
Specialist II
Specialist II
Author

Hey ,

I remove SQL keyword but still same error is there.

SQL##f - SqlState: 07001, ErrorCode: 4294964286, ErrorMsg: [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1.

SQL SELECT * FROM `C:\Users\nikhil.garg\Desktop\Disaster_Data\Copy of Disaster.xlsx`.`Disaster$`

WHERE ModificationTime >= #2014-09-05 14:12:58#

ANd 1 more question :

Do we have to define or declare "ModificationTime" anywhere ??

Anonymous
Not applicable

I think the ODBC connection that is established between  excel file cannot find the file.

Why are you not using the file to directly load it via Table Files button....

Why are you specifically creating an ODBC connection to excel file....

MOREOVER I GOT THE ISSUE.

YOU ARE NOT CREATING THE CONNECTION STRING TO THE PARTICULAR EXCEL FILE .

YOU HAVE DIRECTLY USED THE EXCEL FROM Select BUTTON....

PLEASE SEE THE IMAGE BELOW.

YOU NEED TO HAVE A CONNECTION STRING AND THE THE SQL STATEMENT.

THIS WILL RESOLVE THE PROBLEM....

Capture.PNG.png

nikhilgarg
Specialist II
Specialist II
Author

HEy i ahve resolve the odbc connection problem . But now different problem is there:

SQL##f - SqlState: 07001, ErrorCode: 4294964286, ErrorMsg: [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1.

SQL SELECT * FROM `C:\Users\nikhil.garg\Desktop\Disaster_Data\Copy of Disaster.xlsx`.`Disaster$`

WHERE ModificationTime >= #2014-09-05 14:12:58#

ANd 1 more question :

Do we have to define or declare "ModificationTime" anywhere ??

Please help.

Thanx.