topic Re: Table rotation in the script in QlikView

Table rotation in the script

demoustier — Wed, 17 Jun 2015 07:56:57 GMT

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

Re: Table rotation in the script

MK_QSL — Wed, 17 Jun 2015 08:04:02 GMT

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

];

Re: Table rotation in the script

Anonymous — Wed, 17 Jun 2015 08:04:27 GMT

Hi,

why you want to do this in the script?

Isnt better to do in a pivot table in QlikView?

Regards.

Re: Table rotation in the script

Anonymous — Wed, 17 Jun 2015 08:14:39 GMT

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.

Re: Table rotation in the script

demoustier — Wed, 17 Jun 2015 08:28:34 GMT

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

Re: Table rotation in the script

Wed, 17 Jun 2015 08:31:18 GMT

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;

Re: Table rotation in the script

demoustier — Wed, 17 Jun 2015 08:39:50 GMT

Wooww !!!!

it's works !!!!

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

Re: Table rotation in the script

Wed, 17 Jun 2015 08:50:04 GMT

Please refer the link for more drtails about generic load.

The Generic Load

Regards,

Sindhu Kannan.