topic Re: To convert an Excel file in to qvd format in QlikView

To convert an Excel file in to qvd format

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

Rgds

Neville

Re: To convert an Excel file in to qvd format

m_woolf — Mon, 25 Sep 2017 18:07:39 GMT

Read data into QlikView.

Store into QVD

Re: To convert an Excel file in to qvd format

silvacarlos — Mon, 25 Sep 2017 20:35:09 GMT

I just googled 'Excel store to QVD':

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

[Qlik Sense] - Store into QVD‌

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

Regards.

CS.

Re: To convert an Excel file in to qvd format

Anonymous — Tue, 26 Sep 2017 16:36:49 GMT

1. First load Excel file into qlikview application.

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

Hope it helps!!

Re: To convert an Excel file in to qvd format

its_anandrjs — Tue, 26 Sep 2017 17:45:30 GMT

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;

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

Re: To convert an Excel file in to qvd format

kumarravi — Sun, 10 Apr 2022 18:12:55 GMT

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