Difference between QVD and TEXT

Fri, 22 Jul 2011 05:15:47 GMT

Hi,

In Edit Script, I am trying to create the QVD and TEXT file by using Store command.

After completion of execution and when i opened the Cus2 Text File , then it is showing like Xml Format.

IF we go through with MACRO Code for creating TEXT file then it is showing in different format.

//EDIT SCRIPT EXECUTION

Customers:

LOAD Address,

City,

CompanyName,

ContactName,

Country,

CustomerID,

DivisionID,

Fax,

Phone,

PostalCode,

StateProvince;

SQL SELECT *

FROM Customers;

Store Customers into Cus1.qvd;

Store Customers into Cus2.txt;

//MACRO SCRIPT EXECUTION

sub MyText

set vQvWorkPath = ActiveDocument.Variables("vQvWorkPath")

set obj = ActiveDocument.GetSheetObject("TB02")

set vBMname = ActiveDocument.Variables("vBook")

obj.Export vQvWorkPath.GetContent.String&replace(Date(),"-","")&"_"&replace(Time(),":","")&".txt",","

MsgBox("Data Has Been Transfered")

end sub

NOTE:

What is the main difference between Creating a QVD and TEXT in Edit Script, and what is the performance difference.

Thanks in advance

kji — Fri, 22 Jul 2011 07:36:35 GMT

You need to specify file format as txt, just giving a filename.txt is not enough, use:

Store Customers into Cus2.txt (txt);

topic Difference between QVD and TEXT in QlikView