Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert table

Hi all,

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

Table A:

AreaProduct201120122013
AX102030
AY51015
AZ204060

Table B:

AreaProductYearSales

A

X201110
AX201220
AX201330
AY20115
AY201210
AY201315
AZ201120
AZ201240
AZ201360

Thanks!

Zhou

1 Solution

Accepted Solutions
jchoucq
Partner - Creator III
Partner - Creator III

something like that :

TableB:

CrossTable(Year, Sales, 2)

LOAD Area,

     Product,

     [2011],

     [2012],

     [2013]

FROM

(ooxml, embedded labels, table is Feuil1);

View solution in original post

7 Replies
jchoucq
Partner - Creator III
Partner - Creator III

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
Partner - Creator III
Partner - Creator III

something like that :

TableB:

CrossTable(Year, Sales, 2)

LOAD Area,

     Product,

     [2011],

     [2012],

     [2013]

FROM

(ooxml, embedded labels, table is Feuil1);

tresesco
MVP
MVP

Try like:

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

jvishnuram
Partner - Creator III
Partner - Creator III

Hi Zhou z,

PFA hope it will helps you.

Regards.,

Vishnu

VJ
Not applicable
Author

Hi Zhou,

Try to this statement ,

CrossTable(Year, Sales, 2)

LOAD Area,

     Product,

     [2011],

     [2012],

     [2013]

FROM

(ooxml, embedded labels, table is Sheet1);

Anonymous
Not applicable
Author

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,

Not applicable
Author

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