Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
anscelmo
Contributor
Contributor

Load more than one table from the save QVD file

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

Labels (1)
2 Solutions

Accepted Solutions
Or
MVP
MVP

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;

View solution in original post

anat
Master
Master

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

View solution in original post

2 Replies
Or
MVP
MVP

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
Master
Master

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