Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
arsenal83
Contributor

Loading with transposition

Dear QV Masters,

I have such data in my database:

   

PERIODPARTNERDIM_1DIM_2DIM_3
201301P_011917
201301P_0221018
201302P_0131119
201302P_0241220
201303P_0151321
201303P_0261422
201304P_0171523
201304P_0281624

I would like to transform data to the table:

   

PERIODPARTNERDIMVALUE
201301P_01DIM_11
201301P_02DIM_12
201302P_01DIM_13
201302P_02DIM_14
201303P_01DIM_15
201303P_02DIM_16
201304P_01DIM_17
201304P_02DIM_18
201301P_01DIM_29
201301P_02DIM_210
201302P_01DIM_211
201302P_02DIM_212
201303P_01DIM_213
201303P_02DIM_214
201304P_01DIM_215
201304P_02DIM_216
201301P_01DIM_317
201301P_02DIM_318
201302P_01DIM_319
201302P_02DIM_320
201303P_01DIM_321
201303P_02DIM_322
201304P_01DIM_323
201304P_02DIM_324

Is there any simple way to do this?

1 Solution

Accepted Solutions

Re: Loading with transposition

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);

Capture.PNG

2 Replies

Re: Loading with transposition

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);

Capture.PNG

arsenal83
Contributor

Re: Loading with transposition

THX

Community Browser