topic Re: How do I split records in App Development

How do I split records

Anonymous — Wed, 02 Aug 2017 15:06:16 GMT

Hi all

How do I split records based on odd and even number of rows.

Simply split row number 1,3,5,7,9.. in one QVD file

and 2,4,6,8, ...in another QVD file

Thanks in advance for your help

Re: How do I split records

marcus_sommer — Wed, 02 Aug 2017 15:13:43 GMT

You could try it with:

...

where mod(recno(), 2) = 0; // respectively 1

store ...

- Marcus

Re: How do I split records

micheledenardi — Wed, 02 Aug 2017 15:15:20 GMT

Create a field "Row" which contain the RowNo() and after that use "where" clause to create the two tables:

Main:
Load
rowno() as Row
AutoGenerate(100);

OddTable:
NoConcatenate
Load
Row as OddRows
Resident Main where odd(Row)=-1;

OddTable:
NoConcatenate
Load
Row as EvenRows
Resident Main where even(Row)=-1;

drop Table Main;
Drop field Row;

Re: How do I split records

Anonymous — Wed, 02 Aug 2017 17:58:50 GMT

Hi Michele/ Marcus

Your suggestion is helpful,

Thanks

Re: How do I split records

micheledenardi — Thu, 03 Aug 2017 06:20:37 GMT

Hi Satish,

please mark as correct your favourite solution.