To convert an Excel file in to qvd format

[nevilledhamsiri]

Hi,

Will you summerize the steps to be followed in converting an excel file in to QVD format!

Rgds

Neville

[m_woolf]

Read data into QlikView.

Store into QVD

[silvacarlos]

I just googled 'Excel store to QVD':

http://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/Store....

[Qlik Sense] - Store into QVD‌

https://www.quickintelligence.co.uk/qlikview-qvd-files/

Regards.

CS.

[Anonymous]

Hi

1. First load Excel file into qlikview application.

2. Store Table into Table.qvd(qvd);

Hope it helps!!

[its_anandrjs · Accepted solution]

Best way already suggested by others or maybe have a look

1. Load the excel file and give some name to the table to identify in the data model

Ex:-

SalesTab:

Load *

FROM [SalesData.xlsx] (ooxml, embedded labels, table is Sheet1);

2. Use STORE command to store the table and its row into QVD (Qlikview Data File)

Store SalesTab into SalesTab.qvd;

Or

If you need to store it into some location in your drive / Server then

Store SalesTab into D:\QVD\Proj\SalesTab.qvd;

3. Extention of the store file is *.QVD

Ex:-

//Complete script

SalesTab:

Load *

FROM [SalesData.xlsx] (ooxml, embedded labels, table is Sheet1);

Store SalesTab into SalesTab.qvd;

Note:- If you read this table on the file where you create the QVD you have to drop it first and then use by qvd location

Ex:-

Load

*

FROM SalesData.qvd;

Hope this helps

[kumarravi]

Hey @nevilledhamsiri ,

Sales: //It is the name of the table
LOAD

Col_name 

FROM
[C:\Users\Desktop\x.csv]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);

Store Sales into [C:\Users\Desktop\x..qvd](qvd);