CROSSTABLE

[okalautar]

CROSSTABLE Please How do i choose random columns located at the end of the column list as the qualifiers field in a crosstable of about 2000 column..the columns i want to choose aren't at the beginning of the table.

[vinieme12]

You can force the columns to move to front by creating an empty table

temp:

Load * Inline [

DimYouneed1,DimYouneed2,DimYouneed3

];

Concatenate (temp)

Load * From yourdatasource.qvd;

Main:

CrossTable(DimYouneed1,DimYouneed2,DimYouneed3,3)

Load * Resident temp;

drop table temp;