Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Not applicable

How to store the QVD data into CSV?

Hi All,

I have 100+ QVDs and I want to load QVDs into CSV to use in other ETL.

How to store the QVD data into CSV?

Thanks in advance.

1 Solution

Accepted Solutions

Re: How to store the QVD data into CSV?

Hi,

In the Load script at the end of the tables write

STORE TableName into TableName.csv(txt);

Ex:-

STORE SalesTransaction into SalesTransactionCSV.csv(txt);

Regards

Anand

4 Replies

Re: How to store the QVD data into CSV?

Hi,

In the Load script at the end of the tables write

STORE TableName into TableName.csv(txt);

Ex:-

STORE SalesTransaction into SalesTransactionCSV.csv(txt);

Regards

Anand

neetha_p
Honored Contributor

Re: How to store the QVD data into CSV?

Hi,

Load all QVDs into QV and concatenate in load script,use below code:

Table:

LOAD A, B, C, ....

FROM [QVD file path]\QVD1.qvd

(qvd);

CONCATENATE(Table)

LOAD A, B, C, ....

FROM [QVD file path]\QVD2.qvd

(qvd);

CONCATENATE(Table)

LOAD A, B, C, ....

FROM [QVD file path]\QVD3.qvd

(qvd);

STORE Table into Table.csv(txt);

Regards

Neetha

ngulliver
Valued Contributor III

Re: How to store the QVD data into CSV?

Hi,

If you are still having problems,have a look at:

www.quickintelligence.co.uk/write-csv-qlikview-store/

Cheers,

Neil

Not applicable

Re: How to store the QVD data into CSV?

Hi jjr,

1. load the qvd file in edit script by clinking on "table files"

2. load the data into table..table name must prefix of qvd load script

     <Table Name>:

     Load

     ....

     FROM <[.qvd](qvd)>

3. STORE the data into excel by using STORE Command

Syntax :-

STORE <Table Name> into <path>-- path is here csv file path.

Sub2u

Community Browser