Generating QVD, TXT and CSV File

[lakshmanvepuri]

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

[devarasu07]

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;

[Anonymous]

csv output is not possible...

STORE DATA_UPLOAD INTO (qvd);

STORE DATA_UPLOAD INTO (txt);

[#4]

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/ScriptRegularStatement...

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

[ramasaisaksoft · Accepted solution]

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"

[Anonymous]

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

I think this is not possible?!?

[#7]

Hi Robin,

You can define delimiter as shown below:

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

BR,

Milosz

[Anonymous]

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/ScriptRegularStatement...

[#9]

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/delim...

BR,

Milosz

[Anonymous]

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