Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Generating QVD, TXT and CSV File

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

1 Solution

Accepted Solutions
Highlighted
Specialist III
Specialist III

Re: Generating QVD, TXT and CSV File

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"


View solution in original post

10 Replies
Highlighted
Master II
Master II

Re: Generating QVD, TXT and CSV File

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;

Highlighted
Anonymous
Not applicable

Re: Generating QVD, TXT and CSV File

csv output is not possible...

STORE DATA_UPLOAD INTO (qvd);

STORE DATA_UPLOAD INTO (txt);

Highlighted
Not applicable

Re: Generating QVD, TXT and CSV File

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

Highlighted
Specialist III
Specialist III

Re: Generating QVD, TXT and CSV File

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"


View solution in original post

Highlighted
Anonymous
Not applicable

Re: Generating QVD, TXT and CSV File

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

I think this is not possible?!?

Highlighted
Not applicable

Re: Generating QVD, TXT and CSV File

Hi Robin,

You can define delimiter as shown below:

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


BR,

Milosz

Highlighted
Anonymous
Not applicable

Re: Generating QVD, TXT and CSV File

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

Highlighted
Not applicable

Re: Generating QVD, TXT and CSV File

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

Highlighted
Anonymous
Not applicable

Re: Generating QVD, TXT and CSV File

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