topic Re: transformation of rows into column in QlikView

transformation of rows into column

Tue, 17 Sep 2013 06:26:27 GMT

hi all i want transform my table in excel file

the table is like this

as follows

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6
EMP id	2008	2009	2010	2011	2012
100011100	5	3	4	3	2
10011101	4	5	2	4	5

i have 100 employee

i want transform it into as follows by using qlikview

am attaching excel files

Sokkorn — Tue, 17 Sep 2013 06:32:26 GMT

Hi,

CrossTable can do this job. Let try this script:

[Data]:

CrossTable(Years, Rate,1)

LOAD [Employee Id],

[2012],

[2011],

[2010],

[2009],

[2008]

FROM E_Rating_old.xlsx

(ooxml, embedded labels, table is Sheet1);

See sample attached file.

Regards,

Sokkorn

Tue, 17 Sep 2013 06:40:01 GMT

You can use crosstable () in your script on year & Rating

Might be something like :

Rating:

Crosstable (Year, Raing,1)

Load [Employee Id],

2008,

2009,

......

From (Your source excel);

Once done, you can create a table box listing all the 3 fields i.e. Employee Id, Year, Rating which will give you the desired result.

Hope this helps!

Tue, 17 Sep 2013 08:12:11 GMT

yes exactly

please tell me how to do that step by step i tried can't completed

Sokkorn — Tue, 17 Sep 2013 08:25:19 GMT

Hi,

Follow this: