topic Re: Convert table in QlikView

Convert table

Wed, 18 Dec 2013 07:48:09 GMT

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

Re: Convert table

jchoucq — Wed, 18 Dec 2013 07:51:26 GMT

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

Re: Convert table

jchoucq — Wed, 18 Dec 2013 07:55:25 GMT

something like that :

TableB:

CrossTable(Year, Sales, 2)

LOAD Area,

Product,

[2011],

[2012],

[2013]

FROM

(ooxml, embedded labels, table is Feuil1);

Re: Convert table

tresB — Wed, 18 Dec 2013 07:57:24 GMT

Try like:

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

Re: Convert table

jvishnuram — Wed, 18 Dec 2013 07:59:40 GMT

Hi Zhou z,

PFA hope it will helps you.

Regards.,

Vishnu

Re: Convert table

Wed, 18 Dec 2013 08:00:43 GMT

Hi Zhou,

Try to this statement ,

CrossTable(Year, Sales, 2)

LOAD Area,

Product,

[2011],

[2012],

[2013]

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Convert table

Anonymous — Wed, 18 Dec 2013 08:12:03 GMT

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,

Re: Convert table

Wed, 18 Dec 2013 10:14:06 GMT

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