Add from an ODBC Connection to a Previously Created QVD Table

[#1]

I have the following script:

LOAD [WM Week],

     [Store Nbr],

     [Prime Item Nbr],

     UPC,

     [POS Sales],

     [POS Qty],

     [Curr Str On Hand Qty],

     [Store Specific Retail],

     [Avg Price],

     [POS Cost],

     [SI Prev  Total Retail $],

     [SI Curr  Total Retail $],

     [SI MUMD Qty],

     [SI MUMD Percent],

     [SI Total MUMD $],

     [SI Prev Avg Unit Retail],

     [SI Curr  Avg Unit Retail],

     [Trait Flag],

     [Item Status],

     [Item Type],

     [Prime Item Desc],

     [Order book Flag],

     [Whse Align],

     [Min Order Qty],

     [Max Order Qty],

     [Buyer Full Name],

     [Total Adj Qty ( OH + BR )],

     [Total Adj Retail Amnt ( OH + BR )],

     [Modular Audit Date]

FROM



(qvd);


ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Users\mscoleman\Desktop\Walmart Qlikview\Sales\LastWeek.mdb];

SQL SELECT *

FROM `Qlikview Sales`;

I originally built the QVD from 50 different ODBC connections and I don't want to have to run all of them every time, so I saved them all in a QVD.

How can I add the data from the latest ODBC table to the QVD Table?

Thanks,

Mike

[Anonymous]

You need to load your existing QVD file to the table and then Concatenate data from ODBC

Sales:

LOAD [WM Week],

....

FROM

(qvd);

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Users\mscoleman\Desktop\Walmart Qlikview\Sales\LastWeek.mdb];

Concatenate(Sales)

SQL SELECT *

FROM `Qlikview Sales`;