Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lakshmanvepuri
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

10 Replies
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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