Table rotation in the script

[demoustier]

Good day,

I have a table as below:

Name	Type	Count
X	A	1
X	B	2
Y	A	3
Y	C	4
Z	A	5
Z	C	6
Z	D	7

and I need to have a transposed table generated by the script as below:

Name	A	B	C	D
X	1	2
Y	3		4
Z	5		6	7

In other word, I need to define, in the script, the name of a field by a formula.

Do you think it's possible ?

Any idea ?

Kind regards

[MK_QSL]

Generic

Load * Inline

[

  Name, Type, Count

  X, A, 1

  X, B, 2

  Y, A, 3

  Y, C, 4

  Z, A, 5

  Z, C, 6

  Z, D, 7

];

[Anonymous]

Hi,

why you want to do this in the script?

Isnt better to do in a pivot table in QlikView?

Regards.

[Anonymous]

If you import a Excel file you cando this:

Directory;
LOAD F2,
     F3,
     F5,
     F7,

FROM
[..\External Data\test.xls]
(biff, embedded labels, table is A$, filters(
Transpose(),
Transpose(),
Transpose()
));

Have a look for the second step of importation:

Regards.

[demoustier]

Hi,

I need to export the result by .qvd, it's why I want it in the script (unless there is a possibilties to export a pivot table into .qvd ???)

Unfortunately, the source is not an Excel but directly from a data base

[#6 · Accepted solution]

Try this,

Test:

Generic

Load * Inline

[

  Name, Type, Count

  X, A, 1

  X, B, 2

  Y, A, 3

  Y, C, 4

  Z, A, 5

  Z, C, 6

  Z, D, 7

];

NoConcatenate

Test_Temp:

Load *

Resident Test.A;

Join(Test_Temp)

Load *

Resident Test.B;

Join(Test_Temp)

Load *

Resident Test.C;

Join(Test_Temp)

Load *

Resident Test.D;

DROP Tables Test.A,Test.B,Test.C,Test.D;

[demoustier]

Wooww !!!!

it's works !!!!

What does it means "Resident Test.B" ???

[#8]

Please refer the link for more drtails about generic load.

The Generic Load

Regards,

Sindhu Kannan.