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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference between QVD and TEXT

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

1 Reply
kji
Employee
Employee

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

Store Customers into Cus2.txt (txt);