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

[shantanu73]

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

[julruiz123]

Hi!

This is the way to create a QVD.

Table:

LOAD *

FROM dbSyscom.dbo."Table";

STORE Table INTO $(vQVD)Table.QVD;

DROP TABLE Table;

[etl_tools]

As alternative you can use Advaced ETL Processor for it

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

Mike

[shantanu73]

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

[jagan]

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.