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

[nagarjuna_kotha]

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