topic Re: Trouble converting Excel file into QVD file in QlikView

Trouble converting Excel file into QVD file

Wed, 25 Mar 2015 19:18:27 GMT

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;

Re: Trouble converting Excel file into QVD file

Anonymous — Wed, 25 Mar 2015 19:31:41 GMT

Not sure about this line :

SQL SELECT * FROM zipcode;

Try simply deleting it.

Re: Trouble converting Excel file into QVD file

Wed, 25 Mar 2015 19:57:47 GMT

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

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

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.

Re: Trouble converting Excel file into QVD file

Anonymous — Wed, 25 Mar 2015 20:05:54 GMT

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;

Re: Trouble converting Excel file into QVD file

Thu, 26 Mar 2015 11:12:51 GMT

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 );