topic Loading with transposition in QlikView

Loading with transposition

arsenal1983 — Fri, 04 Dec 2015 10:01:23 GMT

Dear QV Masters,

I have such data in my database:

I would like to transform data to the table:

Is there any simple way to do this?

sunny_talwar — Fri, 04 Dec 2015 17:18:45 GMT

Have you looked at the possibility of using CrossTable() already? If not try that: The Crosstable Load‌

UPDATE:

Table:

CrossTable(DIM, VALUE, 2)

LOAD PERIOD,

PARTNER,

DIM_1,

DIM_2,

DIM_3

FROM

[https://community.qlik.com/thread/194124]

(html, codepage is 1252, embedded labels, table is @1);

arsenal1983 — Tue, 08 Dec 2015 15:04:46 GMT

THX