- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Tags:
- script
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
load the data from qvd then use resident load for other calculations
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
load the data from qvd then use resident load for other calculations