topic Re: CROSSTABLE: HOW TO CHOOSE MULTIPLE COLUMNS AS QUALIFIERS FIELD IN A TABLE CONTAINING 2000 column in Catalog and Lineage

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

Xformation — Tue, 07 Dec 2021 22:35:04 GMT

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.

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

JitenderR — Wed, 02 Sep 2020 13:17:36 GMT

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

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

Xformation — Wed, 02 Sep 2020 13:25:34 GMT

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