How do I store several "LOADS" into a qvd-file?

[#1]

I have several loads from different tables and I want to store ALL data into a QVD-file

When doing this I only store the first set of data (from : LOAD till l:FROM Kunder)

Table_1:

LOAD Bilag,

    KundeID,

   Fra,

   Til,

    Dannetden,

Year(Dannetden) as Year_Dannetden,

Month(Dannetden) as Month_Dannetden,

Day(Dannetden) as Day_Dannetden,

    FakturaSum,

    FakturaSumDKR,

    CountPayUS;

//    "upsize_ts";

SQL SELECT *

FROM Kunder.dbo.KundeBilag;

LOAD SwitchboardID,

    ItemNumber,

    ItemText,

    Command,

    Argument;

SQL SELECT *

FROM Kunder.dbo."Switchboard Items";

LOAD Valuta,

    Kurs;

//    "upsize_ts";

SQL SELECT *

FROM Kunder.dbo.ValutaKurser;

Store Tabel_1 into GammeltPODsystemStamData.qvd;

[sunny_talwar]

May be by joining or concatenating them into one table before you store them

Understanding Join, Keep and Concatenate

[MarcoWedel]

Hi,

you can use a script like this to store all tables into (separate) qvds:

FOR i = NoOfTables()-1 to 0 STEP -1
  LET vTable=TableName($(i));
  Store $(vTable) into $(vTable).qvd;
NEXT i

hope this helps

regards

Marco

[#4]

Hi Marco

Can I store all table into one qvd-file?

[marcus_sommer]

No - a qvd is one table (in a certain structure) and you would need to merge several tables into one table like Sunny mentioned it or very probably better to store each table into a separate qvd like suggested from Marco. What is the reason for this question?

- Marcus