How to transpose a resident table?

Fri, 25 Oct 2013 13:33:11 GMT

PreTable:

Load a,

FROM

[..\Data\foo.tabdel]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

where id = 2;

MyTable:

Load @1, @2

resident Aggregates (filters(Transpose));<-filters here gives syntax error

or any other way to achieve this?

Re: How to transpose a resident table?

Gysbert_Wassenaar — Fri, 25 Oct 2013 13:49:04 GMT

Store the table into a qvd first. When loading the qvd file it is possible to add filters. You can use the File Wizard to create the load statement you need.

topic How to transpose a resident table? in QlikView

How to transpose a resident table?

Re: How to transpose a resident table?