Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | |||||
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
with pivot chart you can move columns to rows and rows to columns
Hope you can Use Aggr on EDesignation with other columns
Regards
Chaitanya
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
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;
in generic load can't get exact result
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
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
Thankyou very much Marco Wedel for ur help.
you're welcome.
please close this thread if there are no further questions.
thanks
regards
Marco