topic Re: Ordering fields before crosstable load in QlikView

Ordering fields before crosstable load

Sat, 06 Jul 2013 16:39:49 GMT

Hi,

I have a table with eleven fields, five of them are text and date fields and the oder six are figures.

I would like to crosstable the table by using :

CROSSTABLE (newfieldname,fieldvalue,5) LOAD

but it does not work properly because the fields in the original table are not oredered being the first five ones the non-figures ones.

Is it necessary to order before crosstable? if so, how to order fields?

Does it exist a sintaxis to explicit the non-figures fields into the crosstable load function?

Thanks

swuehl — Sat, 06 Jul 2013 16:55:17 GMT

Just explicitely state the correct order in the field list of your load statement:

CROSSTABLE (newfieldname,fieldvalue,5) LOAD

TextOrDateField1,

TextOrDateField2,

TextOrDateField3,

TextOrDateField4,

TextOrDateField5,

FigureField1,

FigureField2,

FigureField3,

FigureField4,

FigureField5,

FigureField6

FROM ...;

You need to use the real field names, of course.

CKirsten — Tue, 10 Sep 2019 14:54:10 GMT

What if you need to import the fields dynamically except for the first field that states the test or date field?