Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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);
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);