Concat blocks of X records

[micheledenardi]

Dear All,

is there a way to concat "packs" of 1000 values?

I'm looking for a very fast solution, without using "for" statement. 

Example, this is my original table:

Field1
1
2
3
...
...
...
2789

i would like to obtain

Field

1,2,3,......,1000

1001,1002,.....2000

2001,2002,...,2789

[micheledenardi · Accepted solution]

Found the solution by myself:

EXAMPLE:
Load
    Concat(Field1,',') as Field1
    Group by PackSize;
LOAD Distinct
    Ceil(RecNo(),1000) as PackSize,
    Field1
FROM EXAMPLE.qvd (qvd);