Convert table

[#1]

Hi all,

How to convert my source excel table (table A) to qlikview table (Table B):

Table A:

Area	Product	2011	2012	2013
A	X	10	20	30
A	Y	5	10	15
A	Z	20	40	60

Table B:

Area	Product	Year	Sales
A	X	2011	10
A	X	2012	20
A	X	2013	30
A	Y	2011	5
A	Y	2012	10
A	Y	2013	15
A	Z	2011	20
A	Z	2012	40
A	Z	2013	60

Thanks!

Zhou

[jchoucq]

hi Zhou,

when you load a file, you can make transformation on it.

In your case, in the wizard, you will have to use CrossTable !

Hope this helps

Johann

[jchoucq · Accepted solution]

something like that :

TableB:

CrossTable(Year, Sales, 2)

LOAD Area,

     Product,

     [2011],

     [2012],

     [2013]

FROM

(ooxml, embedded labels, table is Feuil1);

[tresesco]

Try like:

Crosstable (Year,Sales,2) Load * from <>;

[jvishnuram]

Hi Zhou z,

PFA hope it will helps you.

Regards.,

Vishnu

[#6]

Hi Zhou,

Try to this statement ,

CrossTable(Year, Sales, 2)

LOAD Area,

     Product,

     [2011],

     [2012],

     [2013]

FROM

(ooxml, embedded labels, table is Sheet1);

[Anonymous]

Hi Zhou,

by doing this you should have Table B that you need.

CrossTable([2011], Sales, 2)

LOAD ARENA,

     PRODUCT,

     [2011],

     [2012],

     [2013]

FROM

..\Desktop\TEST.xlsx

(ooxml, embedded labels, table is Sheet1);

Regards,

[#8]

Thanks for all your help. I have solved my problem. I ever thought that CrossTable wouldn't work for my institution.