Creation of Partitioned QVD files

[Uma7]

Hi,
i have 72 million records in a table t1 which i want to partition based on a field 'type' and store as partitioned qvd files to load and create sheets.

How can i do this?
Thanks in advance!

[Aurelien_Martinez]

Hi,

You can try to loop over type field, like :

For each vType in FieldValueList('type')

  TMP:
  NoConcatenate
  Load
    *
  Resident t1
  Where
    type = '$(vType)'
  ;
  
  Store TMP into QVD_$(vType).qvd;
  Drop table TMP;

next vType