Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

GenQVD:

noconcatenate

load Names resident SQLTableList

where not exists(Name, Names);


talk is cheap, supply exceeds demand
alexandros17
Partner - Champion III
Partner - Champion III

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