topic Generating QVD, TXT and CSV File in QlikView

Generating QVD, TXT and CSV File

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

Hello.

I want to Store Data into QVD, TEXT File and EXCEL File.

Please consider the below example and let me know how to generate csv and txt file.

DATA_UPLOAD:

SELECT * FROM TABLE_ABC

STORE DATA_UPLOAD INTO ;

STORE DATA_UPLOAD INTO [C:\Local\TEXT.csv];

STORE DATA_UPLOAD INTO [C:\Local\TEXT.txt];

DROP TABLE DATA_UPLOAD ;

Thanks a lot.

Kumar

Re: Generating QVD, TXT and CSV File

devarasu07 — Mon, 13 Mar 2017 08:17:44 GMT

Try like below,

store DATA_UPLOAD into C:\Local\Data.qvd (qvd);

Store DATA_UPLOAD into C:\Local\Data.csv (txt) ;

Store DATA_UPLOAD into C:\Local\Data.txt (txt) ;

DROP TABLE DATA_UPLOAD;

Re: Generating QVD, TXT and CSV File

Anonymous — Mon, 13 Mar 2017 08:19:15 GMT

csv output is not possible...

STORE DATA_UPLOAD INTO (qvd);

STORE DATA_UPLOAD INTO (txt);

Re: Generating QVD, TXT and CSV File

Mon, 13 Mar 2017 08:34:51 GMT

Hi Robin,

Of course it is possible. Please take a look at reference manual under "Store" statement.

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptRegularStatements/Store.htm

CSV is very same as TXT so since QV 8.5 or 9 when storing to txt was released it is possible to create csv files also.

BR,

Milosz

Re: Generating QVD, TXT and CSV File

ramasaisaksoft — Mon, 13 Mar 2017 09:56:22 GMT

Hi Laxmana,

DATA_UPLOAD:

SELECT * FROM TABLE_ABC

STORE DATA_UPLOAD INTO (qvd);-->This will store data in QVD format

STORE DATA_UPLOAD INTO (txt);-->This will store data in Text format

If you feel you got the solution for your issue, please close this thread by clicking "Correct Answer"

Re: Generating QVD, TXT and CSV File

Anonymous — Mon, 13 Mar 2017 10:37:04 GMT

I meant csv in terms of character separated value with configurable delimiter...

I think this is not possible?!?

Re: Generating QVD, TXT and CSV File

Mon, 13 Mar 2017 10:43:29 GMT

Hi Robin,

You can define delimiter as shown below:

Store DATA_UPLOAD into C:\Local\Data.csv (txt, delimiter is ';') ;

BR,

Milosz

Re: Generating QVD, TXT and CSV File

Anonymous — Mon, 13 Mar 2017 10:54:59 GMT

this is absolutely great ... where do you have that information from? From the reference manual? ( I don't have it here at the moment)

You can't read anything about it here:

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptRegularStatements/Store.htm

Re: Generating QVD, TXT and CSV File

Mon, 13 Mar 2017 10:58:09 GMT

This can be confusing because they didn't add this into "Store" statement. However you can find it here:

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptSpecifiers/delimiter.htm

BR,

Milosz

Re: Generating QVD, TXT and CSV File

Anonymous — Mon, 13 Mar 2017 11:00:39 GMT

yes it is confusing, because I know this option from the LOAD statement, but never had the idea using it with store statement... because it is clearly defined as (qvd | txt).

However, now I know it

Re: Generating QVD, TXT and CSV File

nagarjuna_kotha — Mon, 13 Mar 2017 11:23:17 GMT

Try this:

Data:

LOAD Product,

Date,

Val

FROM

(ooxml, embedded labels, table is Sheet2);

STORE Data into E:\Nagarjun\QVD\Data.Qvd(Qvd);

STORE Data into E:\Nagarjun\QVD\Data.txt(txt);