Create 3rd table with value that does not exist in 1 table when compared to another table.

Fri, 09 May 2014 09:56:48 GMT

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 3^rd table is created from 2 existing tables:-

Where not exists

Resident load

Concatenate

Any Ideas how to do the load for GenQVD?

Re: Create 3rd table with value that does not exist in 1 table when compared to another table.

Gysbert_Wassenaar — Fri, 09 May 2014 10:10:41 GMT

GenQVD:

noconcatenate

load Names resident SQLTableList

where not exists(Name, Names);

Re: Create 3rd table with value that does not exist in 1 table when compared to another table.

alexandros17 — Fri, 09 May 2014 10:13:05 GMT

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

topic Re: Create 3rd table with value that does not exist in 1 table when compared to another table. in QlikView

Create 3rd table with value that does not exist in 1 table when compared to another table.

Re: Create 3rd table with value that does not exist in 1 table when compared to another table.

Re: Create 3rd table with value that does not exist in 1 table when compared to another table.