Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Trouble converting Excel file into QVD file

I've browsed this topic and found many helpful ideas; however, am still running into errors.

My script is below and qvw attached; any help is much appreciated!

TRACE;

zipcode:

  LOAD ZipCodeType,

     City,

     State,

     LocationType,

     Lat,

     Long,

     Location

FROM

(biff, embedded labels, table is [free-zipcode-database-Primary$]);

SQL SELECT * FROM zipcode;

STORE zipcode INTO ;

TRACE;

DROP TABLE zipcode;

4 Replies

Re: Trouble converting Excel file into QVD file

Not sure about this line :

     SQL SELECT * FROM zipcode;

Try simply deleting it.

Highlighted
Not applicable

Re: Trouble converting Excel file into QVD file

That did the trick - thank you very much!

Thank you,

Karen

Karen Wallace, MPH

Sr. Decision Support Analyst

Analytics & Business Intelligence

Health First, Inc.

3300 Fiske Blvd.

Rockledge, FL 32955

Office: 321-434-6637

E-Mail: Karen.Wallace@Health-First.org

>>> Bill Markham <qcwebmaster@qlikview.com> 3/25/2015 3:32 PM >>>

Trouble converting Excel file into QVD file

reply from Bill Markham in New to QlikView - View the full discussion

Not sure about this line :

SQL SELECT * FROM zipcode;

Try simply deleting it.

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in New to QlikView by email or at Qlik Community

© 1993-2014 QlikTech International AB | Copyright & Trademarks | Privacy | Terms of Use | Software EULA

#####################################

This message is for the named person's use only. It may

contain private, proprietary, or legally privileged information.

No privilege is waived or lost by any mistransmission. If you

receive this message in error, please immediately delete it and

all copies of it from your system, destroy any hard copies of it,

and notify the sender. You must not, directly or indirectly, use,

disclose, distribute, print, or copy any part of this message if you

are not the intended recipient. Health First reserves the right to

monitor all e-mail communications through its networks. Any views

or opinions expressed in this message are solely those of the

individual sender, except (1) where the message states such views

or opinions are on behalf of a particular entity; and (2) the sender

is authorized by the entity to give such views or opinions.

Highlighted
Specialist
Specialist

Re: Trouble converting Excel file into QVD file

TRACE;

zipcode:

  LOAD ZipCodeType,

     City,

     State,

     LocationType,

     Lat,

     Long,

     Location

FROM

(biff, embedded labels, table is [free-zipcode-database-Primary$]);

STORE zipcode INTO ;

TRACE;

DROP TABLE zipcode;

Highlighted
Not applicable

Re: Trouble converting Excel file into QVD file

Thank you very much for your help!

>>> Jannet Santos <qcwebmaster@qlikview.com> 3/25/2015 4:06 PM >>>

Trouble converting Excel file into QVD file

reply from Jannet Santos in New to QlikView - View the full discussion

TRACE;

zipcode:

LOAD ZipCodeType,

City,

State,

LocationType,

Lat,

Long,

Location

FROM

(biff, embedded labels, table is );

STORE zipcode INTO ;

TRACE;

DROP TABLE zipcode;

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in New to QlikView by email or at Qlik Community

© 1993-2014 QlikTech International AB | Copyright & Trademarks | Privacy | Terms of Use | Software EULA

#####################################

This message is for the named person's use only. It may

contain private, proprietary, or legally privileged information.

No privilege is waived or lost by any mistransmission. If you

receive this message in error, please immediately delete it and

all copies of it from your system, destroy any hard copies of it,

and notify the sender. You must not, directly or indirectly, use,

disclose, distribute, print, or copy any part of this message if you

are not the intended recipient. Health First reserves the right to

monitor all e-mail communications through its networks. Any views

or opinions expressed in this message are solely those of the

individual sender, except (1) where the message states such views

or opinions are on behalf of a particular entity; and (2) the sender

is authorized by the entity to give such views or opinions.