Converting SQL results (typically excel) to QVD to be used in QlikV

[Anonymous]

Hi,

I need to run a SQL script on an external database and then translate these results into .qvd to use in QlikView.  I have searched the community to understand how to do this.  There is lots and lots of information out there and I am getting a little confused.  Does anyone have or know of a demo I could watch to better understand how to run the full process?

Cheers,

Laura

[Siva_Sankar]

can you share your excel file by duplicating the data.

[Anonymous]

Data fudged but I haven’t changed format

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

[Siva_Sankar]

Laura,

I loaded the data with your excel file and attached the qlikview file. Kindly check and let me know if you still have issues.

[Anonymous]

Hi, same syntax error.

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

[Siva_Sankar]

can you share your qvw file and the screenshot of the error that you are getting

[Anonymous]

I tried loading the file in a completely new QVW and it worked fine?

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

[Siva_Sankar]

That's great!

[Anonymous]

Thanks for your help. Another question please. When I did it from new qvw view I loaded the original excel spreadsheet. I did it quickly so I didn’t set any variables. Where does QlikView file the created qvd file without my setting the path? (i.e. QlikView takes the excel and stores it into a qvd file right?)

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

[Siva_Sankar]

By default, if you didn't specifiy the path then qvd will be stored where your qvw file is saved.

[Anonymous]

Hi shankarece.  i am receiving a Script line error when trying to load data from an excel file into a qvd file.  can you please help me?

Targets:
LOAD Team,
team_id,
role,
id,
Consultant,
[1/07/2015],
[1/08/2015],
[1/09/2015],
[1/10/2015],
[1/11/2015],
[1/12/2015],
[1/01/2016],
[1/02/2016],
[1/03/2016],
[1/04/2016],
[1/05/2016],
[1/06/2016]
FROM

(ooxml, embedded labels, table is Targets);

STORE Targets into (qvd)