CROSSTABLE: HOW TO CHOOSE MULTIPLE COLUMNS AS QUALIFIERS FIELD IN A TABLE CONTAINING 2000 columns

[Xformation]

Please How do i choose multiple columns(at different locations i.e column number 998, 1050 etc) as qualifiers  from about 2000 columns in a crosstable.

[JitenderR]

Hi @Xformation Can you elaborate what "qualifiers" mean here? did you mean to choose a set of columns from the table while creating the entity definition?

Regards

JR

[Xformation]

Yes sir, normally I'd type

CrossTable(dimension, value, 2)

LOAD

[Type],

[43466] as january,

[43467] as february

FROM [lib://Desktop/file.xlsx]

BUT what if the columns i want to select isn't the first 2 columns...what if i want to select a column in the middle or at the end