Load more than one table from the save QVD file

[anscelmo]

Hi,

I have only one QVD file.

How can I load more than 1 table 2 times from the same QVD file?

for example:

--table 1

Load "ID", "Person Name", "Country"

From myQVDFile.qvd (qvd);

--table 2

Load "Country", count(*) as "Tot Reg"

From myQVDFILE.qvd (qvd)       // the same QVD file used in table 1

Group by "Country";

And how can I set a custom name to each table?

Thanks

[Or · Accepted solution]

At the risk of getting in trouble with Nike - just do it. There's no issue here and your version will work.

Naming a table internally is done by using e.g.

Table1:

Load SomeField From SomeTable;

Table2:

Load SomeField2 From SomeOtherTable;

[anat · Accepted solution]

load the data from qvd then use resident load for other calculations