topic Re: How to change row values into column headers in qlikview in QlikView

How to change row values into column headers in qlikview

Fri, 19 Sep 2014 10:56:29 GMT

Hi,

Please can any one help me how to solve this

Eid	Ename	Edesignation
	ANU	CEO
1	USHA	MNGR
2	KALYANI	MNGR
3	BHARGAV	TM
4	REDDY	PL
5	ASHOK	MNGR
6	VENKAT	TM
7	ANIL	PL
8	ASHA	AS
9	SIRI	AS
10	NYMI	PL
11	SWE	TM
12	ANIL	AS
13	NAIDU	AS
14	HARSHA	MNGR

I WANT TO CHANGE ABOVE TABLE INTO BELOW SHOWN TABLE

ECO	MNGR	TM	PL	AS
ANU	USHA	BHARGAV	REDDY	NAIDU
	KALYANI	VENKAT	ANIL	ANIL
	ASHOK	SWE	NYMI	SIRI
	HARSHA			ASHA

Re: How to change row values into column headers in qlikview

Anonymous — Fri, 19 Sep 2014 11:29:54 GMT

with pivot chart you can move columns to rows and rows to columns

Re: How to change row values into column headers in qlikview

ychaitanya — Fri, 19 Sep 2014 11:36:21 GMT

Hope you can Use Aggr on EDesignation with other columns

Regards

Chaitanya

Re: How to change row values into column headers in qlikview

dinuwanbr — Fri, 19 Sep 2014 11:40:46 GMT

Hi,

To achieve this easily in script level you can do a generic load.

follow following document for that.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic

BR,

Dinu1

Re: How to change row values into column headers in qlikview

anbu1984 — Fri, 19 Sep 2014 12:08:27 GMT

Load 1 as key ,RowNo() as RowNo, Edesignation & ' ' & Concat(Ename,' ') As Res Group by Edesignation;

lOAD * Inline [

Eid,Ename,Edesignation

,ANU,CEO

1,USHA,MNGR,

2,KALYANI,MNGR,

3,BHARGAV,TM,

4,REDDY,PL,

5,ASHOK,MNGR,

6,VENKAT,TM,

7,ANIL,PL,

8,ASHA,AS,

9,SIRI,AS,

10,NYMI,PL,

11,SWE,TM,

12,ANIL,AS,

13,NAIDU,AS,

14,HARSHA,MNGR ];

NoConcatenate

Final:

Load SubField(SubField(Txt,'|',1),' ',IterNo()) As Col1, SubField(SubField(Txt,'|',2),' ',IterNo()) As Col2,

SubField(SubField(Txt,'|',3),' ',IterNo()) As Col3,

SubField(SubField(Txt,'|',4),' ',IterNo()) As Col4,

SubField(SubField(Txt,'|',5),' ',IterNo()) As Col5

While IterNo() <= RangeMax(SubStringCount(SubField(Txt,'|',1),' '),SubStringCount(SubField(Txt,'|',2),' '),SubStringCount(SubField(Txt,'|',3),' '),SubStringCount(SubField(Txt,'|',4),' ')

,SubStringCount(SubField(Txt,'|',5),' ')) + 1;

Load Concat(Res,'|',RowNo) As Txt Resident Initial Group by key order by RowNo;

Re: How to change row values into column headers in qlikview

Fri, 19 Sep 2014 12:09:59 GMT

in generic load can't get exact result

Re: How to change row values into column headers in qlikview

Fri, 19 Sep 2014 12:28:09 GMT

thankyou Anbu cheliyan but ur solution is not helping to me .

Please check the requirement what i am posted . i want edesignation field values converted into fieldnames

Re: How to change row values into column headers in qlikview

MarcoWedel — Fri, 19 Sep 2014 21:56:41 GMT

Hi,

one solution could be:

tabInput:

LOAD * INLINE [

Eid, Ename, Edesignation

, ANU, CEO

1, USHA, MNGR

2, KALYANI, MNGR

3, BHARGAV, TM

4, REDDY, PL

5, ASHOK, MNGR

6, VENKAT, TM

7, ANIL, PL

8, ASHA, AS

9, SIRI, AS

10, NYMI, PL

11, SWE, TM

12, ANIL, AS

13, NAIDU, AS

14, HARSHA, MNGR

];

tabOutput:

Generic LOAD

AutoNumber(RecNo(), Edesignation) as ID,

Edesignation,

Ename

Resident tabInput;

DROP Table tabInput;

hope this helps

regards

Marco

Re: How to change row values into column headers in qlikview

Sat, 20 Sep 2014 10:52:12 GMT

Thankyou very much Marco Wedel for ur help.

Re: How to change row values into column headers in qlikview

MarcoWedel — Sat, 20 Sep 2014 21:53:30 GMT

you're welcome.

please close this thread if there are no further questions.

thanks

regards

Marco