Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
I am new to QV.
I have 2 set of tables in SQL that get incremented counter added to name (each table average 55 933 802 records). I would like to generate .qvd file for each table.
Populate table with table names from DB
SQLTableList:
Load
name as Names;
select
t.name
from sys.tables t
where name like 'Table0%';
Result for SQLTableList
Table001
Table002
Table003
Table004
Populate table with file names from QVData folder
For Each Ext In 'qvd' // filetype to search for in current directory
For Each File In FileList (Root & '\Table0*.' & Ext)
QVDFileName:
Load
'$(File)' as Name
Autogenerate 1;
Next File
Next Ext
Result for QVDFileName
Table001
Table002
Table003
What I want is table with only the table names I have to generate QVD files for.
Result for GenQVD
Table004
I have investigated the following but did not find any examples where 3rd table is created from 2 existing tables:-
Where not exists
Resident load
Concatenate
Any Ideas how to do the load for GenQVD?
GenQVD:
noconcatenate
load Names resident SQLTableList
where not exists(Name, Names);
Here it is my example,
I have not used exists because you must be sure that one table contains more items than the other, look at my script and let me know