Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

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?

Tags (2)
2 Replies

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

GenQVD:

noconcatenate

load Names resident SQLTableList

where not exists(Name, Names);


talk is cheap, supply exceeds demand

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

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

Community Browser