topic Divide a Qvd into smaller Qvds by Row Number in App Development

Divide a Qvd into smaller Qvds by Row Number

marcel_olmo — Sat, 16 Nov 2024 18:35:20 GMT

Hi guys,

I have a Qvd like this which has several millions of rows:

MyTable :

LOAD
TextField1,
TextField2,

....

FROM [lib://MyTable.qvd]
(qvd);

And I'd like to divide it into smaller Qvds by row Number, to get QVds of maximum 1 million of rows.

I'm trying to do it applying a where clause with a Rowno() function with minimum and maximum values, but it's not working.

Anybody has a clue about how to do this?

Best regards, Marcel.

Re: Divide a Qvd into smaller Qvds by Row Number

Taoufiq_Zarra — Tue, 26 May 2020 16:53:12 GMT

@marcel_olmo

Maye be :

Data: LOAD DIV(rowno(),1000000) as IndexQvd, Field1, Field2 FROM .\MyTable.qvd (qvd); ValueList: load distinct IndexQvd as Valuelist resident Data; NumRows=NoOfRows('ValueList'); FOR i=0 to $(NumRows)-1 LET vBox=Peek('Valuelist',$(i)); Data$(i): noconcatenate LOAD * resident Data where IndexQvd='$(i)'; store Data$(i) into Data$(i).qvd (qvd); drop table Data$(i); NEXT drop table Data,ValueList;

Re: Divide a Qvd into smaller Qvds by Row Number

marcel_olmo — Wed, 27 May 2020 14:49:23 GMT

Thank you @Taoufiq_Zarra !