Open QVD or QVW file in R-Project

Mon, 03 Feb 2014 14:56:11 GMT

How can i open a qvd or qvw file from r-project to work on data mining?

Re: Open QVD or QVW file in R-Project

Mon, 03 Feb 2014 16:59:59 GMT

Hello

QViewer

easyqlik.com

Anonymous — Mon, 10 Feb 2014 15:25:32 GMT

Hi Handry,

Here's an example:

[MeuProjeto2.qvw] need to extract information from a table contained in [MeuProjeto1.qvw]:

Binary ;

Next, make a loop to catalog the tables in qvw to serve as a data source

For i = 0 to NoOfTables()-1

Let vTableName = chr(39) & TableName($(i)) & Chr(39);

Tables:

Load $(vTableName) as TableName

AutoGenerate 1;

Next;

Following, make a loop to extract the desired information storing them in QVD files.

For i = 0 to (NoOfRows('Tables')-1)

LET vTable = '[' & Peek('TableName', $(i), 'Tables') & ']';

LET vQVDName = Peek('TableName', $(i), 'Tables');

// Tabela interesse: [SessionTaskAuditMaster]

IF vTable = '[NomeTabelaDesejada]' THEN

Store $(vTable) into $(vQVDName).QVD;

END IF;

Drop Table $(vTable);

NEXT

Drop Table Tables;

Directory;

Sales:

LOAD Field1 AS SalesDate,

Field2 AS SalesMan,

Field3 AS SalesAmount

FROM NomeTabelaDesejada.QVD(qvd);

Works perfectly! Hope this helps!

Evandro