topic Re: Can we create QVD file directly from sources data i.e(Text, CSV, Etc) in QlikView

Can we create QVD file directly from sources data i.e(Text, CSV, Etc)

shantanu73 — Fri, 01 Jun 2012 06:56:51 GMT

Hello Friends,

At present I am following the following 2 step to create QVD file as follows:-

1. 1st Creation of table in QVW

2. Then we create the QVD file from QVW Table

I want to eliminate the 1st step. ie. Can we create QVD File directly from source data (ie from text, csv, any rdbms tables). So that we can save time.

Waiting for response

Thanks

Shantanu

Can we create QVD file directly from sources data i.e(Text, CSV, Etc)

julruiz123 — Sun, 03 Jun 2012 02:21:25 GMT

Hi!

This is the way to create a QVD.

Table:

LOAD *

FROM dbSyscom.dbo."Table";

STORE Table INTO $(vQVD)Table.QVD;

DROP TABLE Table;

Re: Can we create QVD file directly from sources data i.e(Text, CSV, Etc)

etl_tools — Thu, 18 Oct 2012 14:49:58 GMT

As alternative you can use Advaced ETL Processor for it

http://www.etl-tools.com/generating-qvd-files.html

Mike

Re: Can we create QVD file directly from sources data i.e(Text, CSV, Etc)

shantanu73 — Mon, 29 Oct 2012 05:20:25 GMT

Dear Friends,

I know the way of creating the QVD files. My question is whether we can directly create the QVD files from source data without parking the source data in QVW Tables?.

Regards

Shantanu

Re: Can we create QVD file directly from sources data i.e(Text, CSV, Etc)

jagan — Mon, 29 Oct 2012 12:48:36 GMT

Hi Shantanu,

By using Qlikview alone it is not possible to create a QVD file in single step. You need to load data into a resident table and then store it into QVD using STORE command.

Hope this helps you.

Regards,

Jagan.