Discussion Board for collaboration on QlikView Scripting.
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
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
Result for QVDFileName
What I want is table with only the table names I have to generate QVD files for.
Result for GenQVD
I have investigated the following but did not find any examples where 3rd table is created from 2 existing tables:-
Where not exists
Any Ideas how to do the load for GenQVD?
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