2 Replies Latest reply: May 9, 2014 6:13 AM by Alessandro Saccone RSS

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

    zelda kruger

      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?